Hey devs, I'm stuck with a weird MySQL query that's giving me a headache. I've got a table called `orders` with columns for `id`, `customer_id`, `order_date`, and `total`. The query that's bugging me is: `SELECT * FROM orders WHERE order_date > DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND order_date IN (SELECT order_date FROM orders GROUP BY order_date HAVING COUNT(*) > 1);` Can anyone explain what it's trying to do?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
"PHP Devs, Can Someone Make Sense of This Weird MySQL Query?"
- Thread starter ALEX006
- Start date