Hi, I am very new to MySQL. I normally work with MS SQL. I am querying a MySQL database via .NET Visual Studio 2005.

I have a MySQL database which has a datetime field, I am basically trying to retrieve rows that are 24 hours old. i.e need to retrieve yesterday's data.

I am having real difficulty in finding this where statement.

Can somebody please help?

Thanks

please check da manual under Date and Time functions

if you have trouble choosing the correct function, you may post again