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

1980s Photo Prompts: Easy Online Copy & Paste

Are you on a quest to enhance your photography projects with a touch of nostalgic flair? Look no further than 1980s photo prompts. These car...