Sébastien VAROTEAUX wrote:
> 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...
MySQL works exactly like you want by default. Only exception are BLOB
fields.
--
+----------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Tõnu Samuel |
| /*/ /*/ /*/ \*\_ |*| |*||*| tonu@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Tallinn, Estonia |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------+
