509-261 Cooper Street
Ottawa, Ontario (Canada) K2P 0G3

Michele Foster
(613) 232-7447
michele@wizardev.ca
http://WizarDev.ca/

WizarDev Logo

Professional Web Development, Web Design and Database Solutions

Subscribe to Web Words

Powered by FeedBlitz

RSS Icon Subscribe via RSS

Web Words - Blog

MySQL Replace Function

SQL and Database Things

I’ve needed this a few times lately… very handy.

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

Source

April 17th, 2007

2 Responses to “MySQL Replace Function”

  1. Alex Panait Says:
    November 6th, 2008 at 5:14 am

    Very handy, I was looking for a way to replace strings in MySQL and your line really helped me.

  2. Harry Says:
    September 27th, 2010 at 11:11 am

    Thanks!

Leave a Reply