5.2. mroonga_escape()
¶
New in version 3.08.
5.2.1. Summary¶
mroonga_escape
UDF provides functionality to escape given string.
It also accepts parameter what character should be escaped.
5.2.2. Syntax¶
mroonga_escape()
has required parameter and optional parameter:
mroonga_escape(string)
mroonga_escape(string, special_characters)
5.2.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.2.4. Parameters¶
5.2.5. Return value¶
It returns escaped string.