<cfquery.please.help>

Coldfusion cfquery wildcard?

[zander213]

Hi,

I am trying to create an output of products filtered by a single keyword in a list of keywords:

SELECT ProductName, SKUNumber, ProductImageURL, RetailPrice, LongProductDescription, ProductURL, PrimaryCategory, Brand, Keyword FROM Datafeed WHERE PrimaryCategory = 'Product' AND Keyword = 'KEYWORD WITH WILDCARD' ORDER BY Brand

How do I do this? I have tried * and % - but so far nothing...

Thanks in advance for any feedback!

[Zipper]

use the LIKE operator.

"SELECT * FROM table WHERE column LIKE 'keyword with wildcards' ORDER BY column"