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

by Lalita 04-May-19

0 328


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

How to get number of days between two dates in php?

How to count the length of string in PHP

How can i redirect URLs with htaccess

Comments

    Waiting for your comments

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? How to print all alphabets into upper in php How to change max upload file size in php? How to replace words using string function in PHP PHP Implode() Function PHP Explode() Function How to count the length of string in php How to check whether a variable is numeric or not in php How to set default time zone in PHP How to get default time zone 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