MySQL prepared statements return no data

SET @todayTable := CONCAT(“tbl_CT_”, date_format(curdate(), ‘%Y_%m_%d’), “_409”);

SET @qry := CONCAT('SELECT COUNT(fld_CTId) FROM ', @todayTable);

PREPARE stmt
FROM @qry;

EXECUTE stmt;

This query keeps returning no data in Redash. It works as expected in Sequel Pro. Is there a workaround for MySQL prepared statements?