-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
SELECT f1,f2 FROM t1 WHERE f1=2;

PREPARE av FROM 'SELECT f1,f2 FROM t1 WHERE f1=?';
SET @f1=2;
EXECUTE av USING @f1;
DEALLOCATE PREPARE av;
