Number of users with displayname like 'John%'

0

Please login or register to vote for this query.

(click on this box to dismiss)

case-insensitive

Stack Overflow

Q&A for programmers

-- Enter Query Title
-- Enter Query Description

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

Enter Parameters

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