MySQL if string contains ' symbol how to search in LIKE -

how can search name database if string contains ' symbol?

this query trying search, unable search this.

select  *  distributor name  like'%jeni'%' 

how search text if string contains ' symbol?

you should escape (like in pretty every situation this)

select  *  distributor name  like'%jeni\'%' 

you can find more here