[snip]
I was wondering if anyone knows how to do whole word searches in mysql.
I
have a search textbox that users can enter in multiple words to search
for
in the database, but things like the mysql LIKE match any part of a
word.
Is there a way to search for whole word matches only? Please let me
You mean Full-text searches? Read about them here:
http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
Only works with certain table types. Not InnoDB tables (transactional)
for instance.
Best, Mattias
(ps new to this list - messed up on replying first time)
Original Message -
I was wondering if anyone knows how to do whole word searches in mysql. I
have a search textbox that users can enter in multiple words to search for
in the database, but things like the mysql LIKE match any part of a word.
Is there a way to search for whole word matches only? Please let me know i
3 matches
Mail list logo
