Im have a table in which i have a FULLTEXT search ON (Title, Description) so that i can have these to colmuns indexed for searching the database
[quote]
My question is can i use the 'search' index name in a WHERE CLAUSE when querying search terms?
[/quote]
e.g.
[syntax=php]SELECT ID, Title, Description, Clicks, MATCH (Title, Description) AGAINST ('hotel, rooms, accomodations, guest') AS Score FROM online_directory WHERE INDEX(search) MATCH (Title,Description) AGAINST ('hotel, rooms, guest, accomodations') ORDER BY score DESC;[/syntax] P.S please excuse the code im just trying to explain my self in terms of coding
Kendall