Options for MySQL Regular Expressions
Regular expressions can have options (also known as flags) that modify their behavior. Each engine supports a different set of options.
| Option | Description | Backend value | Portable value |
|---|
| c | Case-sensitive matching | c | (not portable) |
| i | Case-insensitive matching | i | ignorecase |
| m | Multiple-line mode. Recognize line terminators within the string. The default behavior is to match line terminators only at the start and end of the string expression. | m | (not portable) |
| n | The . character matches line terminators. The default is for . matching to stop at the end of a line. | n | (not portable) |
| u | Unix-only line endings. Only the newline character is recognized as a line ending by the ., ^, and $ match operators. | u | (not portable) |