searching a tables field

[the voigts]

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?

Thanks

[neur0maniak]

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:[color=blue]
> 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?
>
> Thanks
>
>[/color]