(This is a request for a good example that shows how to construct a SELECT using CONCAT, then prepare+execute it. Please emphasize the use of @variables versus DECLAREd variables – it makes a big difference, and it is something that novices (include myself) stumble over.)