查询从今天到今天上个月[已结束]

For example : today is 4 april 2015 what I want to do is to select all record between current date to the last month of current date.

Please help!!!!

Date should be an actual MySQL column

This will get the last month:

SELECT * FROM TABLE WHERE date > DATE_SUB(NOW(), INTERVAL 1 MONTH) ORDER BY something DESC;

You most likely meant last day of the current month as indicated in the comments. If that is true, then in your where clause you would use:

where date_field between current_date and last_day(current_date)