Defining case insensitive WHERE...

[Shrum]

I thought I saw this somewhere but can't find it again therefore I'm not sure this is possible...so far everything else is ;-)

How do you define a case-insensitive search? DBI/SQL:Statement uses a term called CLIKE (uses is similar to SQL LIKE but refers to a case-insensitive search)

TIA

 

[vbkris]

mysql is case insensitive by default!!!
ie if u give a query like this:
select column from table where column like '%A%'

it will also return records which have a small 'a'...

correct me if i am wrong...


Known is handfull, Unknown is worldfull