Use part of the variable in mysql query?

[deejayluk]

I think this topic is closed
solution is below

Trying to understand variables

I have found a solution. I used views in mysql.