WHERE vs HAVING
Why do you need to place columns you create yourself (for example select 1 as “number”) after HAVING and not WHERE in MySQL? And are there any downsides instead of doing WHERE 1 (writing the whole definition instead of a column name)? 7 Answers 7