select user_name, user_registration, user_editcount, ipb_address, ipb_expiry, ipb_sitewide

​

from user

left join ipblocks on user_name = ipb_address

where 1=1

​

-- and upper(user_name) like '%ALLEN%'

-- and upper(user_name) like '%KIRK%'

and UPPER(CONVERT(user_name USING utf8mb4)) like '%%'

and UPPER(CONVERT(user_name USING utf8mb4)) like upper('%%')

 -- and UPPER(CONVERT(user_name USING utf8mb4)) like '%PRINTONDEMAND%'

 -- and UPPER(CONVERT(user_name USING utf8mb4)) like '%AHMED%'

and user_registration > 20020420000000

order by user_registration desc

limit 100000

​