[thelist] sql filtering problem

[Christopher Joseph]

>The resultant SQL you want is:

>SELECT Brand_Logo, Brand_Logo_sml, ID, Product_Type, Brand, Model,
>Reference_No, Colour, image, Retail_Price, Delivery_Charge
>FROM kitchen_appliance
>WHERE Brand LIKE 'aeg' and Product_Type LIKE 'Microwave'

Confused!

Why would you use LIKE as a filter if your Brand and Product_Type columns
are not going to contain variant data? i.e These columns should contain
known values shouldn't they.