What is the use of the pipe (|) symbol in MySQL REGEXP patterns?
Using the Pipe (|) Symbol in MySQL REGEXP Patterns
In MySQL REGEXP patterns, the pipe | symbol is used for alternation, meaning it allows matching one pattern or another. It functions like a logical OR between multiple sub-patterns.
- 1
Alternation:
'cat|dog'matches either 'cat' or 'dog'. - 2
Multiple Options: You can combine multiple alternatives, e.g.,
'red|green|blue'matches any of the three colors. - 3
Use with Anchors: You can combine with
^or$, e.g.,^cat|dog$matches strings starting with 'cat' or ending with 'dog'. - 4
Grouping Patterns: Use parentheses to group patterns, e.g.,
^(cat|dog)s?$matches 'cat', 'cats', 'dog', or 'dogs'.
The pipe symbol is useful when you want a single regular expression to match multiple possible alternatives without writing separate REGEXP conditions.