MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Anil Garg Date:July 10 2002 4:13pm
Subject:replace query
View as plain text  
i have a table with 2000 rows.
One column (name answer)has a string ("ok --") in all the rows.(e.g "ok --
yes we support this.").
now i want to remove all these 'ok --' in this column..leaving(e.g yes we
support this)
I tried to do it with the replace query but being a newbie to mysql i
couldnt find the right syntax.
Can someone help.

thanx and regards

replace queryAnil Garg10 Jul
  • Re: replace queryGeorg Richter10 Jul
  • Re: replace queryKeith C. Ivey10 Jul
RE: replace queryLuc Foisy10 Jul