SELECT DISTINCT maintab.BArt FROM y_xxxxxx AS maintab WHERE maintab.HubLst = 16000 AND maintab.TrbwGr = '4m' AND maintab.HW = 30000 AND maintab.BArt IN ('D', 'DA', 'DA4', 'DB', 'DQA', 'Z', 'ZA', 'ZB') >>>> return 1 row: 'ZB' SELECT DISTINCT maintab.BArt FROM y_xxxxxx AS maintab WHERE maintab.HubLst = 16000 AND maintab.TrbwGr = '4m' AND maintab.HW = 30000 AND maintab.BArt IN ('D', 'DA', 'DA4', 'DB', 'DQA', 'Z', 'ZA', 'ZB') AND maintab.BArt IN ('ZB','Z') >>>> return 1 row: 'Z' & 'ZB' Here the create table syntax: CREATE TABLE `y_xxxxxx` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `BArt` char(3) NOT NULL, `MGr` smallint(5) unsigned NOT NULL, `Gen` tinyint(3) unsigned NOT NULL, `Strng` tinyint(3) unsigned NOT NULL, `Ablf` tinyint(3) unsigned NOT NULL, `Trml` tinyint(3) unsigned NOT NULL, `DL` smallint(5) unsigned NOT NULL, `DLTyp` char(1) DEFAULT NULL, `HW` mediumint(8) unsigned NOT NULL, `MaxHW` mediumint(8) unsigned DEFAULT NULL, `Spur` smallint(5) unsigned NOT NULL, `BPRmin` smallint(5) unsigned NOT NULL, `BPRmax` smallint(5) unsigned NOT NULL, `BPRNutzMin` smallint(5) unsigned NOT NULL, `BPRNutzMax` smallint(5) unsigned NOT NULL, `Tmax` double unsigned DEFAULT NULL, `HubLst` mediumint(8) unsigned NOT NULL, `maxTrKraft` decimal(5,2) unsigned NOT NULL, `maxSKraft` decimal(5,2) unsigned NOT NULL, `HKls` tinyint(3) unsigned DEFAULT NULL, `BGrp` tinyint(3) unsigned DEFAULT NULL, `TrbwGr` char(3) NOT NULL, `TrbwGr_HA` char(3) DEFAULT NULL, `TrbwGr_ST` char(3) DEFAULT NULL, `TrbwGr_FW` char(3) DEFAULT NULL, `Freq` tinyint(3) unsigned NOT NULL, `SpngBer` char(10) NOT NULL, `U1Nenn` smallint(5) unsigned NOT NULL, `Es` char(5) NOT NULL, `vStrngGr` tinyint(4) NOT NULL, `vHubKl` decimal(3,1) unsigned NOT NULL, `vHubGr` decimal(3,1) unsigned NOT NULL, `vHubGrNenn` decimal(3,1) unsigned NOT NULL, `vHubGr_Sort` tinyint(4) NOT NULL, `FWTyp` char(5) NOT NULL, `FWBArt` char(5) NOT NULL DEFAULT '-', `BGFW` tinyint(3) unsigned DEFAULT NULL, `vKfGr` decimal(4,1) unsigned NOT NULL, `vKfGrNenn` decimal(4,1) unsigned NOT NULL, `vKfGr_Sort` tinyint(3) unsigned DEFAULT NULL, `MotAusf` char(1) DEFAULT NULL, `TrmlDM` smallint(5) unsigned DEFAULT NULL, `INP2_HA` double NOT NULL, `Grp` tinyint(3) unsigned DEFAULT NULL, `maxMas` mediumint(8) unsigned NOT NULL, `iGes_HA` decimal(6,3) unsigned NOT NULL, `iGes_FA` decimal(6,3) unsigned DEFAULT NULL, `GewLKZ` double unsigned DEFAULT NULL, `ZusatzG` tinyint(3) unsigned DEFAULT NULL, `Ident` char(150) DEFAULT NULL, `GltVonDat` date NOT NULL, `GltBisDat` date NOT NULL, PRIMARY KEY (`Id`,`BArt`,`Freq`,`U1Nenn`,`GltVonDat`,`GltBisDat`) USING BTREE, KEY `Ind_PRIMARY` (`Ident`), KEY `Ind_BArt1` (`BArt`), KEY `Ind_DL` (`DL`), KEY `Ind_Es` (`Es`), KEY `Ind_Freq` (`Freq`), KEY `Ind_HW` (`HW`), KEY `Ind_HubLst` (`HubLst`), KEY `Ind_iGes_HA` (`iGes_HA`), KEY `Ind_maxSKraft` (`maxSKraft`), KEY `Ind_MGr1` (`MGr`), KEY `Ind_MotAusf` (`MotAusf`), KEY `Ind_SpngBer` (`SpngBer`), KEY `Ind_Spur` (`Spur`), KEY `Ind_Strng` (`Strng`), KEY `Ind_TrmlDM1` (`TrmlDM`), KEY `Ind_TrbwGr` (`TrbwGr`), KEY `Ind_TrbwGr_HA` (`TrbwGr_HA`), KEY `Ind_TrbwGr_ST` (`TrbwGr_ST`), KEY `Ind_TrbwGr_FW` (`TrbwGr_FW`), KEY `Ind_U1Nenn` (`U1Nenn`), KEY `Ind_vStrngGr` (`vStrngGr`), KEY `Ind_vKfGr` (`vKfGr`), KEY `Ind_GltVonDat` (`GltVonDat`), KEY `Ind_GltBisDat` (`GltBisDat`), KEY `Ind_BArt2` (`BArt`,`MGr`,`Gen`,`Strng`,`Ablf`,`Trml`,`DL`,`HW`,`Spur`), KEY `Ind_BArt3` (`BArt`,`MGr`,`Gen`,`Strng`,`Ablf`,`Trml`,`DL`,`HW`), KEY `Ind_BArt4` (`BArt`,`MGr`,`Gen`,`Strng`,`Ablf`,`Trml`,`DL`,`HubLst`), KEY `Ind_BArt5` (`BArt`,`MGr`,`Gen`,`Strng`,`Ablf`,`Trml`,`HubLst`,`DL`,`Freq`,`vKfGr`), KEY `Ind_MGr2` (`MGr`,`Strng`,`Ablf`,`HW`,`HubLst`,`maxSKraft`,`TrbwGr`), KEY `Ind_TrmlDM2` (`TrmlDM`,`SpngBer`,`MotAusf`,`iGes_HA`,`maxSKraft`,`TrbwGr_HA`) ) ENGINE=MyISAM AUTO_INCREMENT=22043716 DEFAULT CHARSET=latin1 PACK_KEYS=1 PARTITION BY RANGE COLUMNS(BArt,Freq,GltBisDat) ( PARTITION p00 VALUES LESS THAN ('D',50,'2011-06-30') ENGINE = MyISAM, PARTITION p01 VALUES LESS THAN ('D',50,MAXVALUE) ENGINE = MyISAM, PARTITION p02 VALUES LESS THAN ('D',60,'2011-06-30') ENGINE = MyISAM, PARTITION p03 VALUES LESS THAN ('D',60,MAXVALUE) ENGINE = MyISAM, PARTITION p04 VALUES LESS THAN ('DA',50,'2011-06-30') ENGINE = MyISAM, PARTITION p05 VALUES LESS THAN ('DA',50,MAXVALUE) ENGINE = MyISAM, PARTITION p06 VALUES LESS THAN ('DA',60,'2011-06-30') ENGINE = MyISAM, PARTITION p07 VALUES LESS THAN ('DA',60,MAXVALUE) ENGINE = MyISAM, PARTITION p08 VALUES LESS THAN ('DA4',50,'2011-06-30') ENGINE = MyISAM, PARTITION p09 VALUES LESS THAN ('DA4',50,MAXVALUE) ENGINE = MyISAM, PARTITION p10 VALUES LESS THAN ('DA4',60,'2011-06-30') ENGINE = MyISAM, PARTITION p11 VALUES LESS THAN ('DA4',60,MAXVALUE) ENGINE = MyISAM, PARTITION p12 VALUES LESS THAN ('DB',50,'2011-06-30') ENGINE = MyISAM, PARTITION p13 VALUES LESS THAN ('DB',50,MAXVALUE) ENGINE = MyISAM, PARTITION p14 VALUES LESS THAN ('DB',60,'2011-06-30') ENGINE = MyISAM, PARTITION p15 VALUES LESS THAN ('DB',60,MAXVALUE) ENGINE = MyISAM, PARTITION p16 VALUES LESS THAN ('DQA',50,'2011-06-30') ENGINE = MyISAM, PARTITION p17 VALUES LESS THAN ('DQA',50,MAXVALUE) ENGINE = MyISAM, PARTITION p18 VALUES LESS THAN ('DQA',60,'2011-06-30') ENGINE = MyISAM, PARTITION p19 VALUES LESS THAN ('DQA',60,MAXVALUE) ENGINE = MyISAM, PARTITION p20 VALUES LESS THAN ('E',50,'2011-06-30') ENGINE = MyISAM, PARTITION p21 VALUES LESS THAN ('E',50,MAXVALUE) ENGINE = MyISAM, PARTITION p22 VALUES LESS THAN ('E',60,'2011-06-30') ENGINE = MyISAM, PARTITION p23 VALUES LESS THAN ('E',60,MAXVALUE) ENGINE = MyISAM, PARTITION p24 VALUES LESS THAN ('EKZ',50,'2011-06-30') ENGINE = MyISAM, PARTITION p25 VALUES LESS THAN ('EKZ',50,MAXVALUE) ENGINE = MyISAM, PARTITION p26 VALUES LESS THAN ('EKZ',60,'2011-06-30') ENGINE = MyISAM, PARTITION p27 VALUES LESS THAN ('EKZ',60,MAXVALUE) ENGINE = MyISAM, PARTITION p28 VALUES LESS THAN ('S',50,'2011-06-30') ENGINE = MyISAM, PARTITION p29 VALUES LESS THAN ('S',50,MAXVALUE) ENGINE = MyISAM, PARTITION p30 VALUES LESS THAN ('S',60,'2011-06-30') ENGINE = MyISAM, PARTITION p31 VALUES LESS THAN ('S',60,MAXVALUE) ENGINE = MyISAM, PARTITION p32 VALUES LESS THAN ('U',50,'2011-06-30') ENGINE = MyISAM, PARTITION p33 VALUES LESS THAN ('U',50,MAXVALUE) ENGINE = MyISAM, PARTITION p34 VALUES LESS THAN ('U',60,'2011-06-30') ENGINE = MyISAM, PARTITION p35 VALUES LESS THAN ('U',60,MAXVALUE) ENGINE = MyISAM, PARTITION p36 VALUES LESS THAN ('Z',50,'2011-06-30') ENGINE = MyISAM, PARTITION p37 VALUES LESS THAN ('Z',50,MAXVALUE) ENGINE = MyISAM, PARTITION p38 VALUES LESS THAN ('Z',60,'2011-06-30') ENGINE = MyISAM, PARTITION p39 VALUES LESS THAN ('Z',60,MAXVALUE) ENGINE = MyISAM, PARTITION p40 VALUES LESS THAN ('ZA',50,'2011-06-30') ENGINE = MyISAM, PARTITION p41 VALUES LESS THAN ('ZA',50,MAXVALUE) ENGINE = MyISAM, PARTITION p42 VALUES LESS THAN ('ZA',60,'2011-06-30') ENGINE = MyISAM, PARTITION p43 VALUES LESS THAN ('ZA',60,MAXVALUE) ENGINE = MyISAM, PARTITION p44 VALUES LESS THAN ('ZB',50,'2011-06-30') ENGINE = MyISAM, PARTITION p45 VALUES LESS THAN ('ZB',50,MAXVALUE) ENGINE = MyISAM, PARTITION p46 VALUES LESS THAN ('ZB',60,'2011-06-30') ENGINE = MyISAM, PARTITION p47 VALUES LESS THAN ('ZB',60,MAXVALUE) ENGINE = MyISAM, PARTITION p48 VALUES LESS THAN ('ZK',50,'2011-06-30') ENGINE = MyISAM, PARTITION p49 VALUES LESS THAN ('ZK',50,MAXVALUE) ENGINE = MyISAM, PARTITION p50 VALUES LESS THAN ('ZK',60,'2011-06-30') ENGINE = MyISAM, PARTITION p51 VALUES LESS THAN ('ZK',60,MAXVALUE) ENGINE = MyISAM )