Can i make match query to behave as like query. If i match for ‘ar’ it should bring ‘arabian ranches’
SELECT title,id FROM search WHERE type=‘Buy’ AND MATCH(title) AGAINST(‘ar’)
Can i make match query to behave as like query. If i match for ‘ar’ it should bring ‘arabian ranches’
SELECT title,id FROM search WHERE type=‘Buy’ AND MATCH(title) AGAINST(‘ar’)
no, they are fundamentally different
MATCH AGAINST is fuzzy