Disable escape characters in a MySQL query

Question

Is there a way to disable escape characters in a MySQL query? For example, for the following table:

mysql> select * from test1;
+------------------------+-------+
| name                   | value |
+------------------------+-------+
| C:\\media\data\temp\   |     1 |
| C:\\media\data\temp    |     2 |
| /unix/media/data/temp  |     3 |
| /unix/media/data/temp/ |     4 |
+------------------------+-------+

I want the following to be a valid query:

mysql> select * from test1 where name='C:\\media\data\temp\';

I know that I can instead use

mysql> select * from test1 where name='C:\\\\media\\data\\temp\\';

But I am building this query using my_snprintf(), so there instead I have to use

C:\\\\\\\\media\\\\data\\\\temp\\\\

...and so on! Is there a way to disable escape characters for a single MySQL query ?

Answer 1

You can disable backslash escapes by setting NO_BACKSLASH_ESCAPES in the SQL mode:

-- save mode & disable backslashes
SET @old_sql_mode=@@sql_mode;
SET @@sql_mode=CONCAT_WS(',', @@sql_mode, 'NO_BACKSLASH_ESCAPES');

-- run the query
SELECT 'C:\\media\data\temp\';

-- enable backslashes
SET @@sql_mode=@old_sql_mode;