Question

How to use user variables in MySQL LIKE clause?

Answer 1

set also can be used to assign a select reason to variable provided that you write to select