I have a table where one of the fields has a description that is often a few sentences long. I would like to be able to search this field, but I'm running into a slight problem. I wonder if there's a simple workaround.
Let's say for example the field name is description and some values are:
"indoor and outdoor sports equipment"
Now basically, I would like to devise a search where if a user is looking for the term "door" it only gives results where values contain words that only begin w/ the search term. So for example:
select * from table where desc like "[wordbeginswith]door"
Or some way of doing this without having to parse the results w/ some kind of extra php functions. I would like this statement to only return the entry whose description value is "cool doorbells" and not the others.
I hope I'm being clear w/ what I'm looking to do. Any help would be greatly appreciated!