I have following basic MySQL query and I my aim is to artificially inflate the amount of today's orders by 75%.
Is there a more efficient way of doing this without using
SELECT COUNT(order_id) + (COUNT(order_id) * 0.75) AS total FROM orders WHERE order_date BETWEEN BETWEEN CURDATE() + ' 00:00:00' AND NOW()
EDIT: I spotted an issue with my query (using
+ for concatenation when I should have used