Oracle has bind variables. Bind variables are used to avoid re-parsing requests. For example, if I say
"select * from someTable where number < 100"
"select * from someTable where number < 5000"
the second query requires a complete reparse even though it is very nearly parsed 1 second ago. if 100 and 5000 could be handled by a variable of some type, the parsing could be skipped.
So does mysql have bind variables and can you use them with mysql.