MySQL magic

query.sql

SELECT 
    _utf8 'а' REGEXP CONCAT('^([', x'D0B0', '-', x'D18F', '])*$') as rus_a_regex_check, 
    HEX('а') as rus_a_hex,
    _utf8 'г' REGEXP CONCAT('^([', x'D0B0', '-', x'D18F', '])*$') as rus_g_regex_check, 
    HEX('г') as rus_g_hex,
    _utf8 'т' REGEXP CONCAT('^([', x'D0B0', '-', x'D18F', '])*$') as rus_t_regex_check, 
    HEX('т') as rus_t_hex,
    _utf8 'у' REGEXP CONCAT('^([', x'D0B0', '-', x'D18F', '])*$') as rus_y_regex_check, 
    HEX('у') as rus_y_hex,
    _utf8 'я' REGEXP CONCAT('^([', x'D0B0', '-', x'D18F', '])*$') as rus_ya_regex_check, 
    HEX('я') as rus_ya_hex
;

result.txt

*************************** 1. row ***************************
 rus_a_regex_check: 1
         rus_a_hex: D0B0
 rus_g_regex_check: 1
         rus_g_hex: D0B3
 rus_t_regex_check: 0
         rus_t_hex: D182
 rus_y_regex_check: 0
         rus_y_hex: D183
rus_ya_regex_check: 1
        rus_ya_hex: D18F
1 row in set (0.00 sec)