WHERE in SELECT SQL?

Question

PHP

There is a request like this:

SELECT `money` FROM `table`  WHERE date(`date`) = '2016-08-11'

It is necessary to display in the same query a column where, for example, the amount for the previous day will be displayed.
How to do it without union, i.e. by adding a condition to SELECT?

Answer 1

SELECT [Поле группировки], sum(что сложить) FROM `table`  
 WHERE <условие>
 group by [Поле группировки]

or

SELECT [Поле группировки], sum(что сложить) FROM `table`  
 group by [Поле группировки]
having [условие]

Requests work in much the same way. Only in the first one, we first impose a condition on the table, and then group. And in the second, we first get the data and impose a condition.

Answer 2

SELECT `money` FROM `table`
  WHERE date(`date`) BETWEEN вчера AND сегодня

Answer 3

SELECT `money` AS Today, CAST( NULL AS MONEY) AS Yesterday FROM `table`  WHERE date(`date`) = '2016-08-11'
UNION
SELECT NULL, `money` FROM `table`  WHERE date(`date`) = '2016-08-10'