Re: Select one valuebut not the other
- Date: Wed, 29 Apr 2015 07:08:33 +0200 (CEST)
- From: "Mogens Melander" <mogens@xxxxxxxxxxxxx>
- Subject: Re: Select one valuebut not the other
SELECT * FROM table WHERE item_number=1;
On Wed, April 29, 2015 06:30, Olivier Nicole wrote:
> I am sure that it is feasible with MySQl, and I am sure that's a newbie
> question, but my SQL skills are limited...
> I have a table where each record is made of one item_number and one
> If one item has several values, there are several records with the same
> item_number and a different data_value.
> What is the command to select all the records where an item_number has
> the data 1 but not the data 2?
> Thanks in advance,
+66 8701 33224
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql