Searching KEYWORD in database

wxdqz

New Member
I wrote a search query, it works but it's not perfect: if I search the word DOG the query result gives me only DOG and not DOGS nor MYDOG and that is how I want it. THE PROBLEM IS that it doesn't find DOG when there is a ',' or a '.', i.e. it doesn't find 'DOG;' and it doesn't find DOG when DOG is the first word of a TEXT field of the database.

HOW CAN I SOLVE THIS PROBLEM? I put the query I made here under:

SELECT * FROM db_articles WHERE text LIKE '% ".$keyword." %'
 
Back
Top