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

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

by Lalita 04-May-19

0 932

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 print all alphabets into upper in php

How to print all alphabets into upper in php
HTML Tags Print with PHP Echo Statement

HTML Tags Print with PHP Echo Statement
htaccess deny direct access to folder in website

htaccess deny direct access to folder in website
PHP Signup Script

PHP Signup Script

Leave a Reply

Comments
    Waiting for your comments

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
require() function in php
Difference between echo, print and print_r in PHP
Get the unique id of the last inserted row in PHP MYSQL
array_search() function in php
array_combine() function in php
use of @ in php
isset() function in php
Difference between Public, Private and Protected in PHP
array_merge() function in php
array_change_key_case() function in php
array_count_values() function in php
array_diff() function in php
array_diff_assoc() function in php
array_diff_key() function in php
array_diff_uassoc() function in php
array_diff_ukey() function in php
array_fill() function in php
array_fill_keys() function in php
array_filter() function in php
array_intersect_key() function in PHP
array_intersect_uassoc() function in php
array_flip() function in php
array_intersect() function in php
array_intersect_assoc() function in php
unset function in php
array_key_exists function in php
array_intersect_ukey function in php
array_keys() function in php
array_map() function in php
array_merge_recursive() function in php
array_multisort() function in php
array_pop() function in php
array_push() function in php
array_pad() function in php
array_rand() function in php
array_reduce() function in php
array_replace() function in php
array_reverse() functioon in php
array_shift() function in php
array_unshift() function in nphp
array_slice() function in php
array_splice() function in php
array_sum() function in php
array_udiff() function in php
array_udiff_assoc() function in php
array_udiff_uassoc() function in php
array_uintersect() function in php
array_uintersect_assoc() function in php
array_uintersect_uassoc() function in php
array_walk() function in php
arsort() function in php
asort() function in php
krsort() function in php
ksort() function in php
list() function in php
next() function in php
prev() function in php
current() function in php
end() function in php
reset() function in php
pos() function in php
range() function in php
shuffle() function in php
sizeof() function in php
sort() function in php
rsort() function in php
convert short youtube url to full url in php
preg_replace() function in php
addcslashes() function in php
addslashes() function in php
chop() function in php
chr() function in php
chunk_split() function in php
crc32() function in php
crypt() function in php
echo() function in php
fprintf() function in php
get_html_translation_table() function in php
html_entity_decode() function in php
uploading both data and files on MySQL Server in one form using Ajax?
htmlentities() function in php
htmlspecialchars_decode() function in php
htmlspecialchars() function in php
join() function in php
lcfirst() function in php
ltrim() function in php
md5() function in php
md5_file() function in php
number_format() function in php
print() function in php
printf() function in php
rtrim() function in php
sprintf() function in php
str_pad() function in php
str_repeat() function in php
str_replace() function in php
str_shuffle() function in php
str_split() function in php
str_word_count() function in php
Replacing string and spaces in PHP using str_replace function
strpos() function 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