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
Aucun commentaire:
Enregistrer un commentaire