How to get data one year before till now from database in mysql?

by Lalita 04-May-19

0 121


Answer: To select all records one year ago till today, first of all you have to get the current date for comparing the year with date in your database.

SELECT * FROM users WHERE join_date >= DATE_SUB(NOW(),INTERVAL 1 YEAR);


Share:

Prev Next

You May Also Like

How to check PHP Version

PHP Comments

Numeric Validation in PHP

How to remove .php extension with .htaccess

Comments

    No Comments Yet.

Leave a Reply

PHP Examples

PHP Signup Script PHP Login Script PHP Forget Password Script PHP Comment Tag Update data in MySQL without change the exists file How to retrieve images from MySQL database How to retrieve video from MySQL database PHP Get Current Time Stamp Arithmetic Calculator Change Background Color Multiple Dropdown Selection Delete Multiple Records Enquiry Form with Email Function Pagination Create Random Password Numeric Validation HTML Tags Print with PHP Echo Statement htaccess deny direct access to folder in website htaccess remove index.php from url How remove .php extension with .htaccess How can i redirect URLs with htaccess Export MySQL data to Excel in PHP session_start(): cannot send session cache limiter - headers already sent How to check PHP Version how to get time from MySQL database in PHP How to get data one year before from database in mysql? How to get data one year before till now from database in mysql? Fatal Error Allowed Memory Size Exhausted How to blocked login for few minutes after 2 unsuccessful login attempts? How to get number of days between two dates in php? Some Common Mistakes for PHP Developers to Avoid How to convert amount in crores to decimal value in php?

Hot Deals

Free Tool - SEO and SEM
All-in-one marketing toolkit for digital marketing professionals. Free Trial

View More →

News letter

Subscribe To Never Miss an Article From

YouTube Channel