May 27, 2015

MySQL find string and replace using query



Yes, its possible to find string from database and direct replace new string using SQL query.

See the following example.

"update your_table_name set fieldname = replace(fieldname, ‘string to find’, ‘new string which you want replace’)"

Enjoy!

No comments:

Post a Comment

Integrating Google reCAPTCHA v3 in HTML Form with PHP

  What is Google reCAPTCHA v3? Google reCAPTCHA is a free service that helps protect websites from spam and abuse. reCAPTCHA v3 is the lates...