[thelist] ASP search
John Meyer
johnmeyer_1978 at yahoo.com
Wed Dec 12 13:16:42 CST 2001
At 07:59 AM 12/12/2001 -0500, you wrote:
>Hi,
>
>A friend needs to add a search to her boss' site.
>The db has many fields such as "color", "width", "height",
>"manufacturer", "finish" (cabinet reseller).
>How would she need to add to select through a specific field for a
>specific word?
>Something like: "Select in Manufacturer for the word Western"
>I only know the statement for equals but not contains.....
standard SQL:
select <fields>|*(all fields) from <tablename> where <fieldname> =
<searchterm>;
More information about the thelist
mailing list