Lindsey wrote:
Lets say the table contains the following brandsSAMSUNG SIEMENS SONY If you do a fulltext boolean search with the term: -S*Y -(S*Y) everyting that starts with an S will be excluded... any solutions?
Although I couldn't find a question in your post, I guess you want to know how to find anything that does not (start with 's' and ends with 'y').
Unfortunately the asterisk ('*') will not help, because the manual [1] states: " The asterisk serves as the truncation operator. Unlike the other operators, it should be *appended* to the word to be affected. "
I don't think that full-text indexes were meant for this kind of queries; although it will not use an index at all (so it might be a slow query), using LIKE 'S%Y' or using a regular expression might be a possible solution.
[1] http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html Regards, Jigal.
smime.p7s
Description: S/MIME Cryptographic Signature