Question: What is the best type of query for validating the format of an email address in a MySQL table?

1. a SQL query using partitions
2. a SQL query using IS NULL
3. a SQL query using a regular expression
4. a SQL query using LTRIM Or RTRIM

Answer: The correct answer of the above question is Option C:a SQL query using a regular expression