Likes Received By jamix

  1. sawz liked jamix's post in the thread Replacing Characters in a table column.

    Well, you can use the replace() function: update my_table set my_field=replace(my_field, 'old_text', 'new_text'); You'll have to...

    Jun 13, 2007

  2. aaron_nimocks liked jamix's post in the thread Need a search -> replace query in MYSQL - Get a green!.

    You can do it easier if the abbreviated state name is all there is in the "state" field. Then no replace() is necessary, just do update...

    Jun 13, 2007