List:General Discussion« Previous MessageNext Message »
From:Jani Tolonen Date:May 12 1999 11:04am
Subject:search in a field with TEXT Type
View as plain text  
Antonio Eduardo A. de Sant'Ana writes:
 > Hi U all,
 > 
 > How do I search for a word in a field that has the TEXT Type ?
 > 

Hi!

Just like a word in any other field type. TEXT field is case
insensitive. ...where field_name like '%something%' for example.
Please read the MySQL manual.

Regards,

- Jani

-- 
+---------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___       ==  mysql@stripped         |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|       Jani Tolonen             |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|       mailto: jani@stripped      |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|       Helsinki                 |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____  Finland                  |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
|             /*/             \*\                   Developers Team   |
+---------------------------------------------------------------------+
Thread
search in a field with TEXT TypeAntonio Eduardo A. de Sant'Ana3 May
  • search in a field with TEXT TypeJani Tolonen12 May