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
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