I have a MySQL database that I'm pulling into a datatable in vb.net
Using the data table, I need to run a select statement using the MySQL 'Month'
MyTable.Select("OrderID In (100,110,120,130) AND Month(OrderDate)>=1 AND Month(OrderDate) <= 3)
Apparently the select doesn't have that function call defined. Is there something else that I can use in the select statement, rather than later looping through all the DataRows that are returned and testing the date?
I also tried
MyTable.Select("OrderID IN (100,110,120,130) AND OrderDate >= #1/%/%# AND OrderDate <= #3/%/%#)
But that's not a valid date/time string.