SQL Arena
#1010

Name Prefix Search

CRM suggestions search for users whose name starts with A. Add an index on name so prefix search runs faster.

Speed this query up with an index
SELECT * FROM users WHERE name LIKE 'A%'

Just CREATE/ALTER/DROP — no trailing SELECT needed.

Sign in to submit

Your query result will appear here