This snippet shows, how to save typing effort by using custom variables or procedures in MySQL queries to not have to retype a value twice.