Get yesterday date in SQL

Question

i am try to request date only yesterday but without success...

My query request.

SELECT registeredDaySell FROM new_sell WHERE DATE_SUB(CURDATE(), INTERVAL 1 DAY)

My date is organized this way.

16 September, 2017

Thanks for helping me out.

Answer 1

SELECT producFinalPrice 
FROM new_sell
WHERE WEEK (date) = WEEK( current_date ) - 1