MySQL query help needed to get clients who haven't bought anything in more than 180 days!

Answer 1

SELECT OrdersName,OrdersSurname,OrdersEmail,OrdersPhone from Orders
WHERE TO_DAYS(NOW()) - TO_DAYS(OrdersFinishedTime) > 180
ORDER BY OrdersFinishedTime DESC
LIMIT 1;

Last order which is more than 180 days ago.

Answer 2

try this:

SELECT `OrdersName`, `OrdersSurname`, `OrdersEmail`, `OrdersPhone` FROM `Orders ` WHERE `OrdersFinishedTime` < SUBDATE(NOW(), 180);

Answer 3

Surely something like the following would do the trick.:

SELECT DISTINCT OrdersName,OrdersSurname,OrdersEmail,OrdersPhone FROM Orders
   WHERE OrdersID IN 
       (SELECT OrdersID FROM Orders 
        WHERE OrdersFinishedTime < (NOW() - INTERVAL 180 DAY))

Answer 4

SELECT * FROM Orders WHERE OrdersFinishedTime < DATE_SUB(NOW(), INTERVAL 180 DAY)