September 25th, 2000, 04:46 AM
here if we give the keyword as sony discman shock . the keyword is the product name.
here i have to select datas. here
sony discman is the product name of same.
shock is another product. here i separate the string using explode function, what the thing three records are retrieved. ie.,the same record of product name is retrieved twice.how to solve this .
help me very soon.
September 25th, 2000, 07:58 AM
I think I know what you are asking.
Try using a DISTINCT clause on your select statement.
select DISTINCT product_name from products where product_name like '%sony%' pr product_name like '%discman%'
Hope thats what you are asking.