String matching 1

[DeepBlerg]

Hi,

If i have the following table:

--------------
| ID | Color |
--------------
| 1 | Blue |
| 2 | Red |
--------------

If I have a HTML form and the user inputs in a textfield "The sky is usually blue in color".

How do I do a query where I want ID 1 returned?

 

[TonyGroves]

Do you mean you want to return the ids of all records where the color field value appears in the textfield?

If so, how about:
[tt]
SELECT id FROM tbl WHERE textfld LIKE CONCAT('%',color,'%')
[/tt]

-----
ALTER world DROP injustice, ADD peace;