[SOLVED] MySQL Boolean Logic - Ultra Newbie

[sennetta]

Trying to query the following table:

 

CREATE TABLE `gigs` (
  `id` int(6) NOT NULL auto_increment,
  `postdate` int(30) NOT NULL default '0',
  `gigdate` bigint(20) NOT NULL,
  `location` text NOT NULL,
  `price` varchar(20) NOT NULL,
  `deleted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `postdate` (`postdate`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

 

with the following query:

 

SELECT * FROM gigs WHERE deleted=0 AND id>-1 AND (id=(1 OR 1 OR 1 OR 6 OR 6 OR 6 OR 6 OR 6 OR 6 OR 2 OR 2)) ORDER BY gigdate 

 

and it's only returning the first result it finds when it should return three results: those with unique IDs 1,2, and 6.  What's going on?

 

Cheers,

 

Anthony

[PFMaBiSmAd]

The distributive property does not work in programming.

 

In mysql, use the IN() operator - http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#function_in

[toplay]

... WHERE `deleted` = 0 AND ID IN (1, 2, 6)

[sennetta]

Thank you very much for your help