REGEXP_LIKE

—

Description: Checks if a string matches a regular expression pattern.
Purpose: Data validation and pattern matching.
Syntax: REGEXP_LIKE(string, pattern)
Parameters:
- string: The string to check.
- pattern: The regex pattern to match.
Returns: 1 for a match, 0 otherwise.
Example: REGEXP_LIKE('abc123', '^[a-z]+[0-9]+$') returns 1.
Notes: Supports complex pattern matching.
Use Case: Validating formats like phone numbers or emails.

Comments