LIKE

[web master]

I have this table

CREATE TABLE users_by_username (
    username text PRIMARY KEY,
    email text,
    age int
)

I want to run query like the following

select username from users where username LIKE 'shl%' LIMIT 10;


Always , I want to find only 10 username (Case insensitive) that start with
specific characters , How can I do it efficient? I want to read minimum
partitions and best performance