Multiple columns in MATCH AGAINST

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dada1
    New Member
    • Jul 2008
    • 15

    Multiple columns in MATCH AGAINST

    I'm trying to get results from this query

    Code:
    SELECT ID FROM table1 WHERE MATCH(column1, column2) AGAINST ('text')
    But I get this error
    Code:
     #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.
  • dada1
    New Member
    • Jul 2008
    • 15

    #2
    SOLVED
    I had to add another index:
    Code:
    ALTER TABLE tableADD FULLTEXT(column1, column2)
    so far I added it like
    Code:
    ALTER TABLE tableADD FULLTEXT(column1)
    ALTER TABLE tableADD FULLTEXT(column2)

    Comment

    Working...