List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 4 1999 3:03am
Subject:Re: searching DB
View as plain text  
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
Thread
searching DBJody4 Aug
  • Re: searching DBPaul DuBois4 Aug
  • Re: searching DBRonald Beck4 Aug
Re: searching DBJody4 Aug
  • Re: searching DBPaul DuBois4 Aug