I wouldn't consider that a problem. If you want to search on contains or ends with, you can't use an index. Thus you should use
LIKE.
select * from table where field like %searchtext%
That would give you the functionality you are looking for.
How would you look up a word in the dictionary that ends with ely? You have to flip through every page, you can't take adavantage
of the word index (alphabetical).
- Original Message -
From: Kim Christensen [EMAIL PROTECTED]
To: MySQL List mysql@lists.mysql.com
Sent: Wednesday, June 21, 2006 10:13 AM
Subject: BOOLEAN search with asterisk as preceeding operand?
Hey gang;
If I have understood the boolean search method correctly, from own
experiments and the docs, the asterisk operand cannot be put before a
word - it negates the preceeding word completely. How have you solved
this? I want my searches to match both words that starts with,
contains, and ends with keyword.
I guess I'm not alone to have this problem ;-)
Regards
--
Kim Christensen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
