By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,604 Members | 858 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,604 IT Pros & Developers. It's quick & easy.

Multiple columns in MATCH AGAINST

P: 11
I'm trying to get results from this query

Expand|Select|Wrap|Line Numbers
  1. SELECT ID FROM table1 WHERE MATCH(column1, column2) AGAINST ('text')
But I get this error
Expand|Select|Wrap|Line Numbers
  1.  #1191 - Can't find FULLTEXT index matching the column list
When I put only one column in MATCH it is working, two or more columns within MATCH doesn't work. I've seen people are doing it.
Oct 28 '14 #1
Share this Question
Share on Google+
1 Reply


P: 11
SOLVED
I had to add another index:
Expand|Select|Wrap|Line Numbers
  1. ALTER TABLE tableADD FULLTEXT(column1, column2)
so far I added it like
Expand|Select|Wrap|Line Numbers
  1. ALTER TABLE tableADD FULLTEXT(column1)
  2. ALTER TABLE tableADD FULLTEXT(column2)
Oct 28 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.