Robb Kerr <[EMAIL PROTECTED]> wrote: > I can't seem to get a FULLTEXT search in the form of MATCH...AGAINST to > work. I even copied verbatim the example listed on mysql.com at > (http://www.mysql.com/doc/en/Fulltext_Search.html). When I use... > > SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database') > > it works as expected. However when I use... > > SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('following') > > it doesn't return any results. > > I've got several tables with FULLTEXT indexes and on none of them can I get > this syntax to work. What's up?
Because 'following' is a stopword. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
