By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,441 Members | 1,488 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,441 IT Pros & Developers. It's quick & easy.

searching a tables field

P: n/a
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
Jul 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You mean SQL, right?

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

Is that what you want?

the voigts wrote:
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

Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.