Sometimes you need to replace some text in your Mysql database. Whatever it is (a user ID or a user name), this is the SQL query you need to run:
UPDATE `table` SET `field` = REPLACE(`field`, ‘string’, ‘anothervalue’)
Replace text in mysql table
Discover more from Too Big World
Subscribe to get the latest posts sent to your email.
