Problem with mysql issue

Hi

I would like to know how can i delete a part of a text in a record on mysql databse



Example text

"i have to go"

If i want to delete only the :

i have

From the Sentence how do i do that on enire field records


Thank you
Good day

 

Please if you cann add a sample

 

perhaps do it with php?
put everything in a $var and use something like $var = substr($var,pos1,pos2) and then update the sql query with UPDATE table SET item='$var'

 

I'd use php and regular expressions.

 

Thank you

I am looking to do it in sql straight on the database

Please add a sample

 

UPDATE table_name SET info='to go' WHERE info='i have to go'"

Obviously alter table_name and info

 

Thank you but i need to do it on 500 records at once

How do i do that ?

Thank you

 

UPDATE table SET col = REPLACE(col, 'old text', 'new text')

Code (markup):

and 'new text' can be '' to replace it with nothing aka remove the 'old text'

 

Thank you all done deal

 

Sorry I misinterpreted, I thought you meant just the one record.