SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
Thread: Help with FULLLTEXT syntax
-
Apr 8, 2008, 13:52 #1
Help with FULLLTEXT syntax
I believe the proper syntax for the query I'm after would be:
Code:SELECT * FROM `table` WHERE MATCH (title,description) AGAINST('_search_term_')
#1191 - Can't find FULLTEXT index matching the column list
When I use this query though, all is well:
Code:SELECT * FROM `table` WHERE MATCH (title) AGAINST('templates') OR MATCH (description) AGAINST('templates')
-
Apr 8, 2008, 14:25 #2
- Join Date
- Feb 2004
- Location
- Tampa, FL (US)
- Posts
- 9,854
- Mentioned
- 1 Post(s)
- Tagged
- 0 Thread(s)
to use fulltext indexing, you MUST have an index that EXACTLY matches what you have in your match() request.
Code:alter table `table` add fulltext index (title, description)
Check out our new Industry News forum!
Keep up-to-date with the latest SP news in the Community Crier
I edit the SitePoint Podcast
-
Apr 8, 2008, 14:57 #3
I had added the index to each individual column, but didn't realize I needed to do so for both together.
Thank you very much.
Bookmarks