Archive

Posts Tagged ‘MySQL REPLACE’

Mass Replace String in MySQL Table Database

June 13th, 2008 No comments
Mass Replace String in MySQL Table Database There are basically 2 ways suggested method: 1st, save/copy the database table and use text editor's "search and replace" function and fill table with new content; 2'nd , use MySQL REPLACE function: UPDATE table_name SET column_name = REPLACE(column_name,"original_text","replace_text")

Search and Replace in MySQL Database

November 28th, 2007 No comments
Search and Replace in MySQL Database use MySQL REPLACE function! 1. BACKUP YOUR DATABASE FIRST. 2. From within phpMyAdmin, open your database. 3. And here is the SQL query to replace string in database table: UPDATE table_name SET column_name = REPLACE(column_name,"original_string","replace_string")
GoCache - ByREV-Cache v1.0 - live served in : 0.614233 sec (gzip)