Terminé

create sql request for fetch data from mysql table

i need modyficate this sql reqest below.

I want fetch all records from table which is older than 1 year so for example if today is 2022.07.06 i want all fetch all mails where Product like '%2021%' AND Product NOT LIKE '%2022%' and Dateorder is older 1 year more than date today. all records before 2021.07.06

SELECT Mail, Product, Dateorder FROM pay

WHERE Product LIKE '%2021%' AND Product NOT LIKE '%2022%'

group by mail;

Product type varchar(150)

Mail type varchar(60)

Dateorder tyle datetime

Compétences : MySQL, SQL, PHP, Administration de Bases de données, Programmation de bases de données

Concernant le client :
( 140 commentaires ) Wrocław, Poland

Nº du projet : #34062393

Décerné à:

(171 Commentaires)
7.2

20 freelances font une offre moyenne de 49 $ pour ce travail

bjrupani

Hello hiring member i hope you are doing well i am bhavika i have 6+years experience in php , laravel ,ajax, jquery , javacript, html,css, bootstrap i can do it this query and i can start this right now so please give Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(230 Commentaires)
7.9
letsstartcoding

Hello, I understood your needs, but have few questions, text me and I will clear all my questions right away

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(68 Commentaires)
6.2
sandeepohri1

Hello, I can modify this SQL request that display 1 year older data. I CAN START WORK RIGHT NOW. Kindly contact me so that we can discuss more on the specifics. Thank you

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(144 Commentaires)
6.0
(162 Commentaires)
6.1
rizwange4

Hi There, Good Day, I just read your project requirement and I can do your project. Let us quickly connect on "CHAT" and discuss the requirements of your project I have 10 years of experience in PHP, WordPress, Wo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(117 Commentaires)
6.0
abubakar12345678

Ready to start now I am expert in mysql php. I will fetch data according to your queries. Give me chance to show you good result. Thanks

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(93 Commentaires)
5.7
(44 Commentaires)
5.0
mdjafferali

Hello I am php developer using MySQL Please start chat with me for more details Thanks Jaffer I.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(40 Commentaires)
4.8
neatdev

Hello there, I'm an android app developer and web developer with 8 years experience in java, angular, typescript, kotlin, nodejs, javascript, spring boot and android. I can also develop in php and nodejs for backend e Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(11 Commentaires)
4.5
(9 Commentaires)
4.2
pavansharma2008

Hello there I have read your job description and perfect fit for this job because i have 9+ years experience in software development field and expertise in PHP & Mysql. Right now i am free for new project so let's disc Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(11 Commentaires)
4.2
klishchnazar057

Dear Client! How are you? This is Nazar from Ukraine, a senior full-stack web developer who is proficient in JavaScript and PHP frameworks. I have read your job description very carefully and feel that I am a good fit Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
3.3
giang60

Hello I have read your requirements carefully and got a total understanding of the project .kindly discuss your project in detail with me. No fake commitment,100% quality work. I have more than 9 years of experience Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
3.2
samudram1712

Hi, I have seen your project details regarding the Website. Please elaborate in detail what is the outcome you are desiring from this project. I shall note them down and work accordingly to meet the deadlines. I have e Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)
2.7
jokicmarijan3

⭐⭐PHP Expert⭐⭐ Dear Client! To become a superb web developer and supports the best qualities and satisfaction to the clients with honestly, constant creation and passion: it' my opinion as a web expert. As a senior web Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(3 Commentaires)
1.7
SaleemKhadar

Happy Day, I will build a website with some specific requests, as per requirements, ping me. I Possess expert skills in Full-stack PHP having 14+ years of experience in designing and developing websites/web application Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
agwidfrnd19

Hi There, I am ready to work on your project. I will develop a best quality and professional website for your home improvement company with all the pages and contact forms you mentioned. It will be fully responsive an Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
0.0
itenablers

I have gone through your job requirements and can help you with long term WP requirements. I have over 7+ years of experience in wordpress , woocommerce, Shopify, PHP , Laravel, Python, CodeIgniter, Angular JS, ReactJS Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
zsdf4

I can gurantee for good product. Hey I'm interested in your project, I have read out your requirements. We have 5+ years experience .We have worked on similar Projects to What You are Looking for. We Have A Variety of Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0