Number of users with displayname like 'user%'

0

Please login or register to vote for this query.

(click on this box to dismiss)

i.e. user1020334, etc. case-insensitive

Stack Overflow

Q&A for programmers

-- Number of users with displayname like 'user%'
-- i.e. user1020334, etc.
-- case-insensitive

select
count(id)
from users
where lower(displayname) like 'user%'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached