quotemeta

Definition and usage

quotemeta() function adds a backslash before some predefined characters in the string.

Predefined characters:

• period(.)
• Backslash (\)
• Plus sign (+)
• Asterisk (*)
• question mark(?)
• Square brackets ([])
• Off-font size (^)
• Dollar Sign ($)
• Braces (())

Tip: This function can be used to escape characters with special meanings, such as ( ), [ ] and * in SQL.

Note: This function is binary safe.

grammar

 quotemeta ( string )