Thank you in advance for your help!
----------
Here is my table:
----------
CREATE TABLE `poll_responses` (
`pollr_id` int(11) NOT NULL auto_increment,
`polla_id` int(11) NOT NULL,
`pollq_id` int(11) NOT NULL,
`userID` int(11) NOT NULL,
`other` text NOT NULL,
PRIMARY KEY (`pollr_id`)
)
----------
Here is my data:
----------
INSERT INTO `poll_responses` (`pollr_id`, `polla_id`, `pollq_id`, `userID`, `other`) VALUES
(19, 12, 4, 2, ''),
(18, 13, 4, 5, ''),
(17, 13, 4, 107, ''),
(16, 13, 4, 108, ''),
(24, 10, 4, 11, ''),
(23, 10, 4, 123, ''),
(22, 10, 4, 19, ''),
(20, 12, 4, 12, ''),
(41, 24, 5, 15, ''),
(40, 13, 4, 125, ''),
(38, 13, 4, 1, ''),
(42, 53, 5, 123, 'Callaway Park'),
(43, 53, 5, 2, 'Disney Land'),
(73, 23, 5, 125, ''),
(72, 12, 4, 77, ''),
(56, 36, 4, 138, ''),
(74, 23, 5, 131, '');
I am trying to pull the pollq_id where no row contains userID =131. What I want to get as a result is "4". Instead, what I am getting is all the rows where the userID does not equal 131. What can I do?
----------
Here is my original query:
----------
SELECT pollq_id FROM poll_responses WHERE userID <> 131