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