php - Get results that are between (inclusive) A and D -

i trying figure out how mysql query return results start (eg.) a-d, aka return: - animal - bank - coke - dog not: igloo

seems pretty simple can't figure out efficient way it.

i mean can based on 1 letter:

select * table word 'a%' 

but how multiple letters easily. considered loop 'incrementing letter d doesn't make sense letters. thoughts?

select * table word regexp '^[a-d]';