Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 736
  • Last Modified:

mySQL Match Against: Multiple Columns

This works:
          select * from `organizations` where match (name) AGAINST ('foo bar')

And this works:
          select * from `organizations` where match (keywords) AGAINST ('foo bar')

But this returns an error:
          select * from `organizations` where match (name,keywords) AGAINST ('foo bar')


Here is the error:
#1191 - Can't find FULLTEXT index matching the column list
0
hankknight
Asked:
hankknight
1 Solution
 
mostartCommented:
as the error is already saying it. You need to have a multi column full text index in order to do fulltext search on multiple columns.
this might help you:
http://www.petefreitag.com/item/477.cfm
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now