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