Problem With WHERE Clause

Problem With WHERE Clause

El Forum
Guest

#12

06-22-2012, 10:38 PM

[eluser]james182[/eluser]
1) Yes.

2) My Query

Code:
SELECT * FROM (`default_products_diamonds`) WHERE `shape` = 'Princess' AND `colour` IN ('D', 'E', 'F') AND `clarity` IN ('VVS1', 'VVS2') AND `certification_type` IN ('GIA', 'AGS') AND `carat` >= '0.01' AND `carat` <= '5' AND `cost` BETWEEN 100 AND 100000

Messages In This Thread

Problem With WHERE Clause - by El Forum - 06-22-2012, 01:47 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 01:53 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 02:10 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 02:39 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 03:22 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 03:43 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 04:10 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 04:21 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 06:55 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 06:50 PM

Problem With WHERE Clause - by El Forum - 06-22-2012, 10:34 PM

Problem With WHERE Clause - by El Forum - 06-22-2012, 10:38 PM

Problem With WHERE Clause - by El Forum - 06-22-2012, 10:50 PM

Problem With WHERE Clause - by El Forum - 06-22-2012, 10:56 PM

Problem With WHERE Clause - by El Forum - 06-22-2012, 11:13 PM

Problem With WHERE Clause - by El Forum - 06-22-2012, 11:16 PM

Problem With WHERE Clause - by El Forum - 06-23-2012, 02:12 AM