I have a let list ( MyList) selected from an excel column table used in a where sql query condition :
SQL
set @MyValue= (select Mycolumn from (select column as MyColumn from `MydataBase`.`MyTable`
where column in ($(MyList)) ORDER BY ID desc limit 1 )a);
This code is correct only when i have a not null list but when i have an empty list the reloaded code showed a synthax error near from 'where column in () order by ID desc limit 1 )a);'
it shows like i wrote nothing between ' () ' !!
How can I make Mylist visible in my code even when it is null ? how can i add this ondition ?
Thank you for any help or attention !