Mysql search and replace some text in a field
What Mysql query will do a text search and replace in one particular field in a table?
ie search for 'children eyeglasses' and replace with 'kids glasses' so a record with a field with the value : 'How to buy children eyeglasses online?' becomes: 'How to buy kids glasses online?'.
|