5.4.1. mroonga_escape

5.4.1.1. Summary

mroonga_escape UDF provides functionality to escape given string. It also accepts parameter what character should be escaped.

5.4.1.2. Syntax

mroonga_escape has required parameter and optional parameter:

mroonga_escape  string
                [special_characters]

5.4.1.3. Usage

Here is the example query which use special characters to be escaped:

SELECT * FROM `symbols` WHERE MATCH(`content`) AGAINST(mroonga_escape("+hello_world()", "()") IN BOOLEAN MODE);

Here is the example about special characters which is escaped:

SELECT mroonga_escape("+-<>~*()\"\:");
'\\+\\-\\<\\>\\~\\*\\(\\)\\"\\:

5.4.1.4. Parameters

5.4.1.4.1. Required parameters

There is one required parameter, string.

5.4.1.4.1.1. string

It specifies text which you want to escape.

5.4.1.4.2. Optional parameters

There is one optional parameter, special_characters.

5.4.1.4.2.1. special_characters

It specifies characters to escape.

The default value is +-<>~*()":.

5.4.1.5. Return value

It returns escaped string.