SELECT ORGANIZATION_ID, ORGANIZATION_NAME AS score FROM ORGANIZATIONHow 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
WHERE ORGANIZATION_NAME LIKE 'houston' ORDER BY score DESC, ORGANIZATION_NAME ASC
For more info about LIKE look at: http://www.mysql.com/documentation/mysql/bychapter/index.html#Pattern_matching
Alexander Croes -- http://www.viganed.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
