Saturday, 14 September 2013

Mysql Match Against & Like search

Mysql Match Against & Like search

SELECT * FROM `db`
WHERE MATCH (city) AGAINST ('south ban' IN BOOLEAN MODE)
SELECT * FROM 'db'
WHERE city LIKE '%south ban%'
I have 2 queries, one is use Match against, the other is LIKE,
When I try to search 'south bank'
Match wont return if user type south ban but Like will return the result
How can I improve Match against search?

No comments:

Post a Comment