case insensitive for sql LIKE wildcard statement
- by David Morrow
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