searching a tables field

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
What would the syntax be to search a particular field in a table with a
users search string?

eg table 'item' with fields 'id' 'category' 'name' 'description' and i want
to search description?


Re: searching a tables field

You mean SQL, right?

SELECT * FROM item WHERE description LIKE '%<search string>%';

Is that what you want?

the voigts wrote:
Quoted text here. Click to load it

Site Timeline