How can change the syntax of the query below to a
"LIKE" criteria query?
SELECT ORGANIZATION_ID, ORGANIZATION_NAME,
MATCH (ORGANIZATION_NAME) AGAINST ("houston") AS score
FROM ORGANIZATION
WHERE MATCH (ORGANIZATION_NAME) AGAINST ("houston")
ORDER BY score DESC, ORGANIZATION_NAME ASC
__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
