1064 Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'aid=ass333' at line 1

[arun kaushik]

CREATE DEFINER=`root`@`localhost` PROCEDURE `ref_table`()
BEGIN

declare t_name varchar(20);
declare aid1 varchar(20);
declare get_email varchar(20);

set @aid1 := 'ass333';
set @t_name := (select table_name from aid_ref where aid=@aid1);

set @get_email= CONCAT("SELECT email FROM ",@t_Name,"where aid=",@aid1);

Prepare stmt FROM @get_email;

Execute stmt;

End


if i am executing the same procedure without (,"where aid=",@aid1); in concat function then i get list of all emails in the function,however i need to get specific email id from this procedure

set @get_email= CONCAT("SELECT email FROM ",@t_Name,"where aid=",@aid1);