...

View Full Version : searching through a table



dawilis
01-17-2005, 12:44 AM
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

Brandoe85
01-17-2005, 12:58 AM
Maybe this (http://www.w3schools.com/sql/sql_where.asp) can help you.

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

Classic ASP Design Tips - Search For Keywords on Multiple Fields
http://www.bullschmidt.com/devtip-searchmultiplefields.asp

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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum