Search Access DB for string value

[§tudz]

Hi,

I am making a website which I need to search for a a value,

basically a normal web site search, you know what I mean.

I have one field call 'searchitem' in a table call tbl_Items this is the field I want to store a running list of words to search through.

so the field would contain something like:

book, Lord of the rings, ring, Tolkien etc...

so if some searched for 'Lord of the rings' it would find that record, I would then want to display it, this I can do myself, its just the search I don't know how to implement

thanks,

[Fishcake]

Passing SQL to the DB along the lines of:

Select *
from tbl_items
where searchitem like '%' + 'Searchword' + '%'

Would match all of the following:
searchword
searchwords
12searchwordsBlah

Hope thats what you needed.

[§tudz]

so this will search through the whole field and match any contained words?

so if I had these records


Name:
fish
bread
ball

type:
food
food
toy

search:
edible, fins, gills, eyes
yeast, edible, wheat, healthy
round, plastic, yellow

and sent this query:

Select Name from tbl_items where searchitem like '%' + 'edible' '%'

it would return:

Fish
Food

right?

[Fishcake]

Yep, If i understand your records properly
"Select Name from tbl_items where searchitem like '%' + 'edible' + '%'"
would return:

Fish
Bread

[Memnoch1207]

Wildcard characters are different for MS Access and SQL Server...
MS Access is *
SQL Server is %

[Fishcake]

Cheers Memnoch i wasn't aware of that.

[§tudz]

thanks for that

[§tudz]

that only works if the search data is exectly what is in the field? I want it to be able to match a word from the field?

such as if data iitem had this in it:

fish sea shark waves

and the statement was looking for the word shark if would show that record?

[§tudz]

no matter,

thank you,

I have found a how to get it o works

Thanks again.