At 2:50 PM +1200 8/4/99, Jody wrote:
>hello I want to be able to seach my database, I want to search by ItemName.
>I need some help trying to figure this out. could you point me in
>the right direction?
>this is what my table looks like...
>CREATE TABLE Items (
>ItemID VARCHAR(25) NOT NULL,
>ItemName VARCHAR(75) NOT NULL,
>ItemDescription MEDIUMTEXT NOT NULL,
>ItemCost DECIMAL(7,2) NOT NULL,
>Category VARCHAR(75) NOT NULL,
>ShippingCost DECIMAL(6,2) NOT NULL
Can you be more specific? Do you want something other than just:
SELECT * FROM Items WHERE ItemName = "something"
Paul DuBois, paul@stripped