(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.)