hankknight
asked on
sql to create multi column full text index (mySQL)
This query returns an error because a multi column full text index is needed:
select * from `organizations` where MATCH (`name`,`keywords`,`descri ption`,`cu stom_keywo rds`,`naic s_keywords `, `naics_desc`, `p_city`, `promo_text`) AGAINST ('foo bar' WITH QUERY EXPANSION)
Could you please give me the sql query I need to create a multi column full text index on the columns needed for the above query?
Thanks!
select * from `organizations` where MATCH (`name`,`keywords`,`descri
Could you please give me the sql query I need to create a multi column full text index on the columns needed for the above query?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
check this for details:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html