Need Mysl query for find and replace a field
Posted on 2013-11-16
I have little experience in making modifications in mysql. But thanks to Experts-Exchange I am able to make little changes, via phpmyadmin.
I have a database named "foobar" and one of the tables in it is named "foobar_menu", And in that table is a field named "params"
I would like the query to search the params field for (include all the quotes) :
And replace it with
That's "all" I want it to do. An exact match and exact replace
phpMyAdmin - 220.127.116.11
MySQL client version: 5.0.95
Server version: 5.0.95-log
And, yes I have a backup of the database.