following is my query that I am trying to search name contain special character e.g. ' symbol
SELECT * from distributor where name like'%jeni's%'
when I tried to add backslash if work in MySQL but wont work in sq light database I also tried following query
SELECT * from distributor where name like'%jeni\'s%' can someone help me to how can i search if string contains ' symbol