.png){kind=tracking}
|
Step-1: Login to CpanelFirst, Login to Your CpanelOutput should be: Step-2: Click on phpMYadminSecond, Click on "phpMYAdmin" from DatabaseOutput should be: Step-3: Select a DatabaseOutput should be: |
Finally
Click on SQL and copy paste following codes and Run it.
Change the table name and Column Name according to you sql
UPDATE Your_Table_Name SET Column_Name = SUBSTRING_INDEX(Column Name, '<quter>', -1);
Look <quter> , All Strings will Remove <quter> and after <quter>.
Original: WWE Raw <quter> New Game
Replace: WWE Raw
index.txt
Example:
MYSQL
UPDATE script1 SET name = SUBSTRING_INDEX(name, ' by ', -1);
Output should be:
| How to delete row id from 1 to 1000 in PHPmyAdmin | PHPmyadmin Tutorial |
| How to delete all Duplicate Rows except for One in MySQL | PHPmyadmin Tutorial |
| How to remove everything after a string by PHPmyadmin | PHPmyadmin Tutorial |
Read Full:: | PHPmyadmin Tutorial |
Category: | Web Tutorial |
Sub Category: | PHPmyadmin Tutorial |
Uploaded: | 3 weeks ago |
Uploaded by: | Admin |
Views: | 77 |