How to do a non case-sentive select ?

[Sébastien VAROTEAUX]

Hi,

I would like to know if it's possible (and how to) to do a non case-sentive
select in a table (with Perl + MySQL)...

Ex :
    select title from table where title like '%test%'

I would like that it's return : Test, tEst, teSt or TEst...

Thanks,
Zak