Question

REGEXP does not take collation into account.

(a) True

(b) False

I got this question by my school teacher while I was bunking the class.

The origin of the question is External Security: Preventing Unauthorized Network Access topic in section Access Control and Security of MySQL

Answer 1

The correct option is (a) True

The explanation is: MySQL provides pattern matching based on the ‘REGEXP’ operator and regular expressions that are similar to those used in Unix programs, namely, grep, sed and vi. REGEXP does not take collation into account.