SELECT * from table where BINARY name REGEXP '[A-Z]{2,7}';

This matches everything that I am looking for except I want it to return whatever is matching the regexp. How can I do this in mysql