Mastering Development

MySQL query – how can be done this query?

How can this query be done? No SET or DECLARE used but newVariable can be used in this query structure. I’m beginner in mysql. Plz let me know if somebody can help me. SELECT newVariable.FieldName FROM (SELECT dbTable.FieldName FROM dbTable WHERE (dbTable.FieldName IN conditions)) newVariable;