-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
EXPLAIN SELECT * FROM words WHERE w LIKE 'A%';
EXPLAIN SELECT * FROM words WHERE w LIKE '%A%';
EXPLAIN SELECT * FROM words WHERE SUBSTRING(w,1,1) = 'A';
EXPLAIN SELECT * FROM words WHERE SUBSTRING(w,2,1) = 'A';
