Quick Search:
 
 mySQL: Search and Replace Jump to:  
Category: >> mySQL >> Search and Replace  

<< lastnext >>

Snippet Name: Search and Replace

Description: Very fast search and replace 1-liner.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: February 28th, 2009

--Changes "A" TO "B":
 
UPDATE user_data SET some_column = REPLACE(some_column,'A','B');


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org