SET @ip_address = '78.31.67.68'; -- Enter the IP address you want to check here

select case when count(*) > 0 -- If an entry exists in ipblocks table, it is blocked else not blocked

                 then 'IP is blocked'

                 else 'IP is not blocked'

       end as 'Blocked or not?'

from ipblocks

where ipb_user = 0 -- Filter IP addresses

and HEX(INET6_ATON(@ip_address)) between ipb_range_start and ipb_range_end; -- Check is given IP is blocked or range blocked