[Solved] How can I use MySQL alias in Where condition


I found concatenating must be done in where condition

select table_date from table_name where concat(DATE_FORMAT(now(),'%Y-%m'),'-',table_date) < curdate()

solved How can I use MySQL alias in Where condition