This is my string in sql column
"Horlicks Health and Nutrition Drink Chocolate Delight- 1kg"
if i type "%Horlicks%" then it work and show but if i type "%horlicks 1kg%" then it not show
i want write a like sql query
select pname from products like="%Horlicks%"
it work but if we type
select pname from products like="%Horlicks 1kg%"
then it not show and 1kg is mention in my string