List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 4 1999 3:29am
Subject:Re: searching DB
View as plain text  
It would help to have a description of the type of search you want to
run...

At 3:07 PM +1200 8/4/99, Jody wrote:
>for now, just to get me started I only want to search the ItemName... I will
>be using PHP to do this but I just need some pointers
>
>
>----- Original Message -----
>From: Paul DuBois <paul@stripped>
>To: Jody <kat@stripped>; <mysql@stripped>
>Sent: Wednesday, August 04, 1999 3:03 PM
>Subject: Re: searching DB
>
>
>> 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
>>
>


-- 
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