On Wed, 26 Sep 2007, Micah Anderson wrote: > SELECT count(*) > FROM bayes_token > WHERE id = '4' > AND ('1190846660' - atime) > '345600';
Who the hell wrote *that* query? Is MySQL smart enough to rearrange that equation to give an indexable comparison? -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ [EMAIL PROTECTED] FALaholic #11174 pgpk -a [EMAIL PROTECTED] key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- Pelley: Will you pledge not to test a nuclear weapon? Ahmadeinejad: CIA! Secret prison in Europe! Abu Ghraib! -- Mahmoud Ahmadeinejad clumsily dodges a question (60 minutes interview, 9/20/2007) ----------------------------------------------------------------------- 242 days until the Mars Phoenix lander arrives at Mars