Black Friday sale is now on! 50% off Laravel: The Modular Way. Learn more

MySQL find and replace

David Carr

PHP & MySQL Tutorials

    There are times when you need to bulk update a database. Such as changing all references of domain.com to domain.blog 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,'daveismyname.com','dcblog.dev')

     

    Laravel Modules Book by David Carr

    Help support the blog so that I can continue creating new content!

    Subscribe to my newsletter

    Subscribe and get my books and product announcements.

    © 2009 - 2022 DC Blog. All code MIT license. All rights reserved.