dimanche 21 août 2016

query with slashes

I have item name like girl's bag's. so query becomes like below

SELECT * 
FROM tbl_product 
WHERE itm_name LIKE '%girl's bag's%' 
    AND status = '1' 
    AND is_available = '1' 
ORDER BY itm_id DESC 
LIMIT 20

I have item with name girl's bag's. but i am not getting any result. Can anyone help , how should i format my item name to match with item in databse.

Aucun commentaire:

Enregistrer un commentaire