Welcome to WebmasterWorld Guest from 188.8.131.52
Forum Moderators: open
SELECT * FROM table
productName != ''
AND value >= '2'
AND time = '3'
AND hasExtras = '1'
AND startDate >= '2012-05-10'
AND startDate <= '2012-05-16'
AND startDate != '2012-05-13'
AND productCode IN ('a1','a2','a3','a4','a5','a6','a7','a8','a9','a10','a11','a12','a13','a14')
OPTIMIZE TABLE tablename;
it appears that the ORDER in which I put things in a query has an effect on how many rows are used in a query
I would think the query optimizer would pick up on this, doesn't make sense that it wouldn't.
then you won't notice any difference no matter what order you put them in. I think that's where the query optimizer automatically "fixes" the order.
field_a='x' AND field_b='y' AND field_c='z'