Check out example codes for "mysql sql select one day before". It will help you in understanding the concepts better.

Code Example 1

SELECT * 
  FROM TABLE t
 WHERE t.date BETWEEN DATE_SUB('2010-07-29', INTERVAL 1 DAY)
                  AND '2010-07-29'

Learn ReactJs, React Native from akashmittal.com