lundi 9 mai 2016

android sqlight how to search string in like if string contains ' symbol

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