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]
