mysql where/having

select * from t1 where id<5;
select * from t1 where id<5;

where 从t1中筛选内容

而having从*中筛选内容