so you are saying that SELECT * FROM some_table WHERE some_date LIKE "2010%" is not possible?
On Dec 3, 9:30 am, bruno desthuilliers <[email protected]> wrote: > On 3 déc, 17:37, owidjaya <[email protected]> wrote: > > > in php I can run the following query for mysql > > > SELECT * FROM some_table WHERE some_date LIKE "2010%" > > > How do i do this in django using cursor.execute()? > > sql = "SELECT * FROM some_table WHERE YEAR(some_date)=%s" > cursor.execute(sql, (2010,)) -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
