View Full Version : Detecting word boundarys in a search

05-02-2004, 07:21 PM
I have a search engine on my site using php/mysql. It works fine, but it doesn't detect word boundarys! Kind of annoying when you search for 'are' and come up with 'share'. I would like some tips on how to make it boundary sensitive. I imagine regular expressions would be useful here but I'm not very familiar with them.

05-02-2004, 08:28 PM
Did you think about using a Full Text search? http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html

Not sure if there is an easy regex. Depends a bit about the sort of values you're searching in. Are they all afanumeric?

05-02-2004, 08:42 PM
Most entries would contain just letters but some may contain numbers aswell. I'll check out the link.