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