Sometime you need to replace some string urls with some thing else in your database table. This is very hard to replace the string or urls in database table manually one by one.
Mysql replace query will save your development time. If you used the mysql replace query then, you no need to delete the data from database and then again insert that dat in your database table. Rather delete and insert new data, you can replace your with correct one.
Use the following SQL query to generate the SQL queries that you need to replace a value in all columns.
'UPDATE my_table SET ',
' = REPLACE(', column_name, ', ''a'', ''e'');')
where table_name = 'my_table';
If you like FreeWebMentor and you would like to contribute, you can write an article and mail your article to [email protected] Your article will appear on the FreeWebMentor main page and help other developers.
Article Tags: mysql query replace, mysql replace example, mysql replace query, mysql replace query example, mysql replace syntax, replace mysql query, replace query in mysql, string replace in mysql query