Doubt in Stored Procedure MySql - how to return multiple values for a variable? -

I have a stored procedure I intend this process to return the names of all the movies acted by an actor Keep me

  ScreenName Writings (50), Type Out in Title Writings (50)) MovieTitle contains titles in the Natural Acts from the movies, where the Acts. Screen name = 'screen name'; End;  

I make a call like Call Actor MVis ('Zony Depp', @movie);

  Select @mova;  

I get the result, which is not right. I hope to return to films by Zoney Depp. I'm not sure why this is happening?

In your where section, you want to round single quotation marks screen name (and possibly rename it to avoid ambiguity with the column name).