Help with mySql please

Example

http://www.lawfirmlawyer.com/Illinois/Springfield/John-V-Boshardy-amp-Associates-l3438.html

You see the title as "John V. Boshardy & Associates"

I am trying to correct that and update the title field to remove "amp;" from the db field.

update `listings`
replace ('amp;' , `listings`.`title`, ' ')

Any help please
============


Thanks

 

Hi, try:

update `listings` set `title`=replace(`title`,'&',' ');

Code (markup):