I am querying for a unicode word in join. When I use LIKE in the where condition, it gives more number of results as compared to using MATCH in BOOLEAN MODE. But when I am trying to find the differences between the queries, it is giving null results. This happens only when the search word is unicode.
This is the query for finding differences having the queries -
select * FROM (select tw.*,us.description, us.location from toys tw join
users us on tw.user_id=us.user_id WHERE toys_text LIKE '%गोपाला%') AS table1
WHERE NOT EXISTS (
select tw.*,us.description, us.location from toys tw join users us on
tw.user_id=us.user_id WHERE MATCH (toys_text) AGAINST ('गोपाला*' IN BOOLEAN
MODE)
)
Edit -
Example - गोपाला* does not match with राम_गोपाला or गोपाले but like search - %गोपाला% finds both of them
So, why is there difference between results of the like and match queries when search word is unicode ? And why the sql query for finding the difference between the 2 queries gives null results ?