Find Replace search text in a mysql table field | Samir Patel - Web Applications Developer, Belmont NC 28012 * 704-345-2040

Home

SQL / mysql

Tag it:

This little query updates a search string and replaces it with a replace string.

Find and replace query for mysql

UPDATE `table_name` SET `field_name` = replace(`field_name`, 'search_term' , 'replace_term' )

Last Updated ( Thursday, 28 January 2010 )

Tag it:

The mysql default configuration is such that only local applications can access the server.

After checking all the firewall configurations, this solution was the only one that worked.

Elegance in simplicity perhaps?

Tag it:

The select statement has to be one of the most useful statements in SQL. The queries mentioned here can be used across the board with most of the popular databases out there including my personal favorite, mysql. Write comment (0 Comments)
Last Updated ( Sunday, 22 June 2008 )
Read more...