Re: REGEXP - search for "something\QQQsomething"

[Felix Geerinckx]

Consider the following (slightly changed) example:

USE test;
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (
d CHAR(20) NOT NULL
);

INSERT INTO foo VALUES ('\\QQQsomething');
SELECT * FROM foo;
SELECT * FROM foo WHERE d REGEXP '^\QQQ';
SELECT * FROM foo WHERE d REGEXP '^\\QQQ';
SELECT * FROM foo WHERE d REGEXP '^\\\QQQ';
SELECT * FROM foo WHERE d REGEXP '^\\\\QQQ';

only the first and the last SELECT produce a result, because the regexp string is parsed twice: once by normal string parsing (turning '\\\\' into '\\') and once by the regexp engine (turning '\\' into '\').

--
felix
Please use BBCode to format your messages in this forum.