I need to listing out name of the person start from lowercase a to g and uppercase A to G in MySQL. You can use MySQL regexp to get the results you want.
Example SQL:
SELECT * FROM USERS WHERE name REGEXP '^[A-G|a-g]'
The above query will listing out all the results where name start from a to g