word search

[Hameedullah]

Hi everyone,

I am having difficulty with writing a search function that searches the database for keywords. How can I write a sql query so that it returns those records that contain the keyword as a word not part of a word.

I tried using wildcards like this

select * from mytable where title like '% keyword %' or title like '% keyword,%' or title like '% keyword.%' or title like '% keyword!%'

This will only return those records that have the keyword delimited by space or space and a punctuations. It wont return any results if the keyword is mentioned in the start of or end in that field. Any suggestions?

PS: Can't do fulltext search on the database

You are either the slave of what made men or what men made.

 

[camaleonCHILE]

hi, can you write a example ? something like "I have this record.... and wanna get this..."

regards, Camaleon CHILE

 

[amrita418]

Why not add those too as part of the search criteria?

title like 'Keyword %'
or title like '% keyword'

Regards,
AA

 

[Hameedullah]

I found a solution guys... thanks.

I used another field and put all the keywords "with a preceding and trailing spaces" like " adsl modems netcomm " for a record that had Netcomm ADSL Modems. Doing search of that new field rather than title.

You are either the slave of what made men or what men made.