Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

mysql sql drupal wordpress database mac osx convert textmate date command backup ip url replace find user list line table log update query data regex csv php terminal order email path search security unix mail magento Bash linux cache code copy regexp filter forms text joomla cakephp server customer class windows format web iphone ajax api xml android actionscript window animation magentoextension apache Business service

Welcome To Snipplr

Everyone's Recent MySQL Snippets Tagged update

« Prev 1 Next »

MySQL Remap values inside a MYSQL query using CASE...WHEN syntax

How to remap a value to another inside a mysql query select.

update

0 1551 posted 13 years ago by ginoplusio

MySQL Update database fields with search replace word

Used to update a database field using search replace.

update

0 1167 posted 14 years ago by carouselcreative

MySQL Simple Concurrent Update

update

0 1094 posted 14 years ago by mantosz

MySQL Updated mysql database from SQL dump

update

0 1354 posted 14 years ago by greeneggs614

MySQL Move WordPress to another host

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.

update

1 1277 posted 15 years ago by errkk

MySQL Insert or update if unique key already exist

update

2 1346 posted 16 years ago by Zwendel

MySQL Conditional String Replace

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

update

1 1545 posted 16 years ago by iroybot