This function escapes special characters in a string to make it safe for use in Mroonga full-text search queries.
mroonga_escape (string [,special_characters])string - required parameter specifying the text you want to escape
special_characters - optional parameter specifying the characters to escape
mroonga_escape is a (UDF) included with the , used for escaping a string. See for details on creating this UDF if required.
If no special_characters parameter is provided, by default +-<>*()": are escaped.
Returns the escaped string.
This page is licensed: CC BY-SA / Gnu FDL
SELECT mroonga_escape("+-<>~*()\"\:");
'\\+\\-\\<\\>\\~\\*\\(\\)\\"\\: