Horje
How to remove everything after a string by PHPmyadmin

Step-1: Login to Cpanel

First, Login to Your Cpanel

Output should be:

Step-2: Click on phpMYadmin

Second, Click on "phpMYAdmin" from Database

Output should be:

 

Step-3: Select a Database

Output 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:




Category:
 Web Tutorial
Sub Category:
 PHPmyadmin Tutorial
Uploaded by:
 Admin


 

Horje