Home › Forums › General Webmaster Forum ›

Case-insensitive replace with Mysql

Submitted by Anonymous on Sun, 05/03/2009 - 18:14

Attention!!! This query will convert all matched records to lowercase, backup first!

UPDATE my_table SET my_text_field = REPLACE( LOWER(my_text_field), 'bad_string', 'good_string')
where my_text_field like '%bad_string%'

I tried to replace some spam-like words from a news queue. I tried this sql query above without where clause first. It was a big mistake because all queue converted to lowercase. I already read docs on mysql.man pages. But there is no function for a case-insensitive replace. I am still searching for a solution. Thanks for any help!

Bookmark/Search this post with
‹ Search in text files recursively with PHP - Grep Update / overwrite files and directories recursively with Linux mv - cp commands ›
Tags:
Submitted by Anonymous (not verified) on Sun, 04/10/2011 - 01:42.

I need it to and subscribe! In my example all these words must be replaced with Canada.

CANADA
canada
cAnada
canaDA
...

Submitted by Anonymous (not verified) on Wed, 05/16/2012 - 06:40.

genius! Thanks!

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Use <pre> all your html php come here </pre> for your code
  • Allowed HTML tags: <a> <b> <pre> <h1> <h2> <h3> <h4> <h5> <h6> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <div> <style><img> <br> <blockquote>
  • Lines and paragraphs break automatically.
  • You may insert videos with [video:URL]

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.

CafeWebmaster.com(CW) is a free online community for webdevelopers and beginners. Anybody can share their code, articles, tips, tutorials, code-examples or other webdesign related material on the site. Newbies can submit their questions and reply to existing questions. CW does not guarantee or warrant reliability of code, data and information published on the site. Use the site on your own risk. The site takes no responsibility of direct or indirect loss or any kind of harm to its users. The site also doesn't take responsibility of infected files or source code with any kind of infection or viruses, worms, spywares, malwares, trojan horses. CW reserves the right to edit, move, or delete any of content for any reason.