谷歌表格查询语言:转义撇号 [英] Google Sheets Query Language: escape apostrophe

问题描述

如何在 Google 表格中的 SQL 查询中转义撇号?

How can I escape an apostrophe inside a SQL query in Google Sheets?

这是我的功能:

=QUERY(QUERY(IMPORTRANGE("XXXXXXX", "XXXXXX!A1:C"),"SELECT * WHERE Col2 = 'Woman's blabla: blablabla'"),"SELECT Col1, Col2")

我尝试添加另一个撇号:

I've tried adding another apostrophe:

=QUERY(QUERY(IMPORTRANGE("XXXXXXX", "XXXXXX!A1:C"),"SELECT * WHERE Col2 = 'Woman''s blabla: blablabla'"),"SELECT Col1, Col2")

运气不好..我试过加一个反斜杠，也没有运气:

No luck.. and I've tried putting a backslash, no luck as well:

=QUERY(QUERY(IMPORTRANGE("XXXXXXX", "XXXXXX!A1:C"),"SELECT * WHERE Col2 = 'Woman/'s blabla: blablabla'"),"SELECT Col1, Col2")

文档的语言环境是英国.

The locale of the document is UK.

推荐答案

尝试在带有撇号的单词周围使用双引号

Try using double quotes around the word with the apostrophe

"SELECT * WHERE Col2 = ""Woman's blabla: blablabla"""

这篇关于谷歌表格查询语言:转义撇号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！