Searching for one word within a field

Anon

Hi,

I have a blob field that has book reviews in it. I want to let users search for specific words within this field.

Right now I have the search like this:
blah, blah, blah '%$fieldname%'

The problem with this is that a search for "man" would pull up "woman" also. I want it to search through the entire blob field and only show the specific word, "man", and nothing else.

How do I do this?

Anon

Couldn't you do

blah, blah, like "% $word %"

Anon

Hi all
I would really appreciate if somebody can help me write a sql query to search for a particular word say american in a text field named linkdesc
Anupam

Anon

try this...

select id from table where linkedesc like '%american%'

that should work for you

Anon

thanks guys it works. I was missing the second % sign in the wildcard
Regards
Anupam

Anon

Hi all,
That's is ok, but if the word is the first into sentence o the last, what happen?
Becasuse "% word %" is fine where it isn't fist and not last.
If the word it's the first or last of one text, how can you search that exactly word?
I have tested "like 'word'" but it doesn't work.

Anybody can help me ?
Thanks you.

Anon

Hi Estaban
I am new to this so I am not sure if this will work. Try this
You have to make three queries
1. for the normal case.ie if its is in he middle of the sentence
-like % word %

for the first of the sentence
-like % word%(the space at the beginning)
for the last of the sentence
-like % word.%(you may put the period if you think that the data fiel has a period at the end
Anupam

Anon

Esteban I think there is something wrong with your query...I've done a search on the first word and the last word and it works fine...
CHEERS

Anon

May I know how you guys solve it? What is the correct query to use?

Regards.

Anon

Hello,
Is there anyway where I can solve it with one query?

Sheryl