On 3 déc, 17:37, owidjaya <owidj...@gmail.com> 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 django-us...@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.

Reply via email to