postgresql - 换行符会影响 Postgres LIKE 文本搜索吗？

Question

所以我将以下内容存储在 Postgres 的文本列中......

This is a sentence.\nAnd here we start a new sentence.\nThen finally we have a third sentence.

那些 \n 会影响该列上的 LIKE 查询吗？

即SELECT "tracks".* 从 "tracks"WHERE (info LIKE '%sentence%')

我问的原因是我想要换行符以正确格式化文本输出，但显然不希望它们搞砸搜索。

Answer 1

只要您将换行符存储为换行符，它就不会弄乱您的查询。

CREATE TABLE example(
   id serial PRIMARY KEY,
   text TEXT NOT NULL
);

INSERT INTO example (text) VALUES (E'This is a sentence.\nAnd here we start a new sentence.\nThen finally we have a third sentence.')

SELECT * FROM example WHERE text LIKE '%nAnd%'; -- 0 records returned
SELECT * FROM example WHERE text LIKE '%And%'; -- 1 record returned

当我将它插入到表中时，请注意字符串前面的E。