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
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