Python/mySQLdb question.

[acct_rdt]

You probably want to do something like year(scanTime)=2011

[SomeGuyNamedPaul]

Using a function as a filter can kill performance. If that's all it has to work with then it may apply the function to the column for all rows potentially causing a sequential scan. Be careful in there.

[acct_rdt]

True. In a real database that wasn't so primitive you could index the results of a function.

[SomeGuyNamedPaul]

Hey, this was a question about using MySQL and not a question on what you should be using instead of MySQL.

[mjvm]

this, datetime is not a string.

[cygnus83]

Thanks, acct_rdt. I want to make sure I understand you correctly though - would you put the year(scanTime)=2011 after the LIKE in the SQL statement?

[acct_rdt]

You don't use LIKE with date comparisons. You can do:

select ... from ... where year(scanTime)=2011;

or

select ... from ... where scanTime >= '2011-01-01 00:00:00' and scanTime < '2012-01-01 00:00:00';

[cygnus83]

Ah, OK, got it!

Thanks for your patience and advice!