MySQL find and replace

David Carr

1 min read - 5th Mar, 2017

There are times when you need to bulk update a database. Such as changing all references of to in a table of hundreds of records. Doing this manually would be very tedious a better way is to do a find and replace in MySQL directly.

How this works is you do an update specify the table then set the column to be updated and inside a replace command set the column then what you’re looking for and what to replace it with.

update table set column = replace(column,'find','replace')

A practical example of this is:

update posts set content = replace(content,'','')


Add a comment

Copyright © 2006 - 2024 DC Blog - All rights reserved.