Thread: how to find and replace a word in a mysql column?
View Single Post
  #2   IP: 204.45.15.210
Old 2015-12-19, 11:02 PM
New Britain New Britain is offline
初级会员
  
Join Date: 2007-08-11
Posts: 1
New Britain 现在声名狼藉
Default
This query works for this:
Code:
UPDATE table SET column = REPLACE(column, 'eyeglasses', 'glasses');
Reply With Quote