Untitled query #64763

SQL

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 '%kas%'
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
SQL

Checking query status...
