case insensitive for sql LIKE wildcard statement

Posted by David Morrow on Stack Overflow See other posts from Stack Overflow or by David Morrow
Published on 2010-05-20T18:39:45Z Indexed on 2010/05/20 18:40 UTC
Read the original article Hit count: 206

Filed under:
|

sorry if this is a repeat, i looked around some and didnt find what i was after so here goes

SELECT * FROM trees WHERE trees.`title` LIKE  '%elm%'

this works fine, but not if the tree is named Elm or ELM ect... how do i make sql case insensitive for this wild-card search?

again apologies if this is repeated. oh, using MySql 5 on apache

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql