faqts : Computers : Databases : MySQL : Shell Commands : mysql

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

32 of 75 people (43%) answered Yes
Recently 6 of 10 people (60%) answered Yes

Entry

SELECT date COUNT(*) WHERE date=todaysdate;//how to select on current date, without typing in current date?

Mar 14th, 2001 20:03
Oliwier Ptak, Jason Parrett,


You could do it like that

SELECT .... WHERE TODAYS(NOW())=TODAYS(date)

so just use NOW() function