When I run this query:
UPDATE searches SET keyword = REPLACE(keyword,"'","") WHERE keyword LIKE "%'%";
I get this error:
Duplicate entry '1039-parkinsons-basic' for key 'uID' – 647 ms
What is the best way to overcome this? I've changed the search code so that new searches are stripped of apostrophes. Now I'm just trying to clean up what's in the database.