View Full Version : searching through a table

01-16-2005, 11:44 PM
Hi I am trying to search through a table that contains search words formated like this
Table Name: tblsearch
Field Name: Keywords
contents of keywords: anything, in,here,is,searchable,word,and,all
my query is
Select * from tblsearch WHERE Keywords LIKE 'here' ORDER BY DESC
will that return all the data in keywords contining the word 'here'?????

at the moment its returning nil results

01-16-2005, 11:58 PM
Maybe this (http://www.w3schools.com/sql/sql_where.asp) can help you.

01-17-2005, 01:15 PM
And perhaps this may hopefully give you some ideas:

Classic ASP Design Tips - Search For Keywords on Multiple Fields

01-17-2005, 10:31 PM
Thanks guys this has helped me clariffy my needs better
Ill start another topic with the next question