create sql request for fetch data from mysql table
Budget: $10 – $30 USD
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
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