Come impostare la query??

[marketto]

1.
SELECT * FROM tabella
WHERE campo LIKE '_a%'

2.
SELECT * FROM tabella
WHERE campo REGEXP '([0-9]{2})[a-zA-Z](.*)';

3.
SELECT * FROM tabella
WHERE campo REGEXP '([a-zA-Z]{2})([0-9]{2})(.*)';