MySQL functions in where statement

[jgrusewski]

Currently I'm facing the following issue.
I would like to do some date/time comparison queries like:
SELECT * FROM mytable WHERE DATE(mydate) = DATE(NOW())

Q: SELECT * FROM mytable WHERE (DATE(mydate) = ?) LIMIT 1000
A: [0000]
E: "Error 1054: Unknown column 'DATE(shipping_date)' in 'where clause'"
T: 0.00039s

What is the best way to approach this issue?

[xiam]

You can use the db.Raw type to pass conditions that you would not like to treat as arguments and should be passed without any kind of filtering:

col.Find(db.Raw{`DATE(mydate) = DATE(NOW())`})

[jgrusewski]

Thanks for your quick reply