Web lists-archives.com

Re: Select one valuebut not the other

SELECT * FROM table WHERE item_number=1;

On Wed, April 29, 2015 06:30, Olivier Nicole wrote:
> Hi,
> 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
> data_value.
> 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,
> Olivier

Mogens Melander
+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