Rowby Goren
asked on
Need Mysl query for find and replace a field
Hello
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) :
"show_page_heading":1,"
And replace it with
"show_page_heading":0,"
That's "all" I want it to do. An exact match and exact replace
phpMyAdmin - 2.11.11.3
MySQL client version: 5.0.95
Server version: 5.0.95-log
And, yes I have a backup of the database.
Thanks!
Rowby
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) :
"show_page_heading":1,"
And replace it with
"show_page_heading":0,"
That's "all" I want it to do. An exact match and exact replace
phpMyAdmin - 2.11.11.3
MySQL client version: 5.0.95
Server version: 5.0.95-log
And, yes I have a backup of the database.
Thanks!
Rowby
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
Rowby