What is the use of the pipe (|) symbol in MySQL REGEXP patterns?

Q: What is the use of 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. **Alternation:** `'cat|dog'` matches either 'cat' or 'dog'. **Multiple Options:** You can combine multiple alternatives, e.g., `'red|green|blue'` matches any of the three colors. **Use with Anchors:** You can combine with `^` or `$`, e.g., `^cat|dog$` matches strings starting with 'cat' or ending with 'dog'. **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. SELECT name FROM employees WHERE name REGEXP 'Alice|Bob'; SELECT word FROM dictionary WHERE word REGEXP 'cat$|dog$'; SELECT color FROM products WHERE color REGEXP 'red|green|blue';

Difficulty: 5/10

REGEXP syntax, alternation operator, pattern matching

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.

Key Points About the Pipe (|) Symbol

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., matches strings starting with 'cat' or ending with 'dog'.

The pipe symbol is useful when you want a single regular expression to match multiple possible alternatives without writing separate REGEXP conditions.

Example: Match Names 'Alice' or 'Bob'

Example: Match Words Ending with 'cat' or 'dog'

Example: Match 'red', 'green', or 'blue'

Scenario Questions

0-2 years experience

Follow-up Questions