SELECT 'tingyi' REGEXP 'kang [division division] [Fu Chuanfu] this statement according to the logic of regular should return 1 (TRUE) but the fact is 0 (FALSE), however,
SELECT 'tingyi' REGEXP '[t t] [Fu Chuanfu] is 1 and SELECT' tingyi 'REGEXP', 'is 1, can you explain why
Also SELECT 'tingyi' REGEXP 'kang [division division] [Fu Chuanfu] to SELECT' tingyi 'REGEXP' kang (t | division) (fu | | pay) 'is 1