List:General Discussion« Previous MessageNext Message »
From:Tonu Samuel Date:August 24 2000 3:13pm
Subject:Re: How to do a non case-sentive select ?
View as plain text  
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 |
+----------------------------------------------------------------+
Thread
How to do a non case-sentive select ?S├ębastien VAROTEAUX24 Aug
  • Re: How to do a non case-sentive select ?Tonu Samuel24 Aug