[thelist] sql filtering problem
Christopher Joseph
Christopher at ideadesigners.com
Tue Aug 27 08:24:02 CDT 2002
>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.
More information about the thelist
mailing list