Re: case insensitve SQL search is possible

[Roger R Dingledine <arma@mit.edu>]

not that i'm paying any attention to what you guys are doing here,
but i've always found the infoseek behavior to be nice.

if i use all lowercase, i want case insensitive searching.
if i use mixed, i want it to try to match case.

i don't know if this is common enough behavior that you want to
do it though.

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