Skip to content

Gary Pendergast

I'm on the Internet

Tag: MySQL Forge

Case Insensitive REPLACE() for MySQL

One request I occasionally see is for a case insensitive version of REPLACE() for MySQL. I wrote this a while back, but here it is now for all of you to play around with. It uses a basic naïve string search algorithm, so can be slow under some circumstances. [code lang=”sql”]DELIMITER $$ DROP FUNCTION IF… Continue reading Case Insensitive REPLACE() for MySQL

Published February 15, 2009
Categorized as MySQL Tagged function, MySQL, MySQL Forge, replace
Picture of Gary Gary Pendergast, noun: MySQL, WordPress, web and music geek. Writes poetry with Automattic. Can be observed in his natural habit at pento.net, or usually in Melbourne, Australia.

  • Twitter
  • Facebook
  • GitHub
  • Photo blog
Gary Pendergast
Privacy Policy
Proudly powered by WordPress.