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

by Lalita 04-May-19

0 587


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 can i redirect URLs with htaccess

PHP Explode() Function

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

how to get time from MySQL database in PHP

Leave a Reply

Comments

    Waiting for your comments

World's Fastest VPN Services

World's Fastest VPN Services


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
PHP Parse_Str Function
How to get the first character of string in PHP
How to get amount in words in php
PHP Date Time Set Function
PHP Get Current Time of Day Function

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