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 professional and enthusiast 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 to meta site
loading Hold tight while we fetch your results