Mateobus Posted August 7, 2006 Share Posted August 7, 2006 I have rows listed in my database where there is 1 column called the date column that is a date element (XXXX-XX-XX). How do I run a select query that selects only the rows where the date is today or before today... Quote Link to comment Share on other sites More sharing options...
ryanlwh Posted August 7, 2006 Share Posted August 7, 2006 [code]SELECT * FROM table WHERE date=CURDATE()[/code] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.