Welcome To Snipplr
Everyone's Recent MySQL Snippets Tagged update
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
« Prev 1 Next »
How to remap a value to another inside a mysql query select.
0
1332
posted 12 years ago by ginoplusio
Used to update a database field using search replace.
0
1008
posted 13 years ago by carouselcreative
SQL query to update *wp_options* records that are specific to the host of a WordPress site. Run this query after copying the DB to another server (if this URL is different). Useful for deploying WordPress from a dev server to a live environment.
1
973
posted 14 years ago by errkk
as a note to self... in order to find it laters...
This will only alter the value of fieldname if the conditions in the WHERE clause are met. With replace we only replace a certain string within fieldname with the replace_with string
1
1108
posted 15 years ago by iroybot
« Prev 1 Next »