case insensitve SQL search is possible

[Aaron Turner <aturner@linuxkb.org>]

LCASE(str) 
LOWER(str) 
       Returns the string str with all characters changed to lowercase
according to the current character set mapping (the default is ISO-8859-1
Latin1). This function is
       multi-byte safe. 

       mysql> select LCASE('QUADRATICALLY');
               -> 'quadratically'


So all we have to do is take the user input and convert it to all lower
case, and then use "select LCASE" to do case insensitive matching.  Cool.
:)

--
Aaron Turner, Core Developer       http://vodka.linuxkb.org/~aturner/
Linux Knowledge Base Organization  http://linuxkb.org/
Because world domination requires quality open documentation.
aka: aturner@vicinity.com, aturner@pobox.com, ion_beam_head@ashtech.net