发送反馈
查询语法参考文档
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
下表包含完整的 Search Ads 360 查询语言语法
参考。
语法参考文档
查询
SELECT
子句
SELECT FIELD_NAME (, FIELD_NAME )*
FROM
子句
FROM RESOURCE_NAME
WHERE
子句
WHERE CONDITION (AND CONDITION )*
ORDER BY
子句
ORDER BY ORDERING (, ORDERING )*
LIMIT
子句
LIMIT POSITIVE_INTEGER
PARAMETERS
子句
PARAMETERS LITERAL = VALUE (, LITERAL = VALUE )*
字段名称
[a-z] ([a-zA-Z0-9._])*
资源名称
[a-z] ([a-zA-Z_])*
条件
FIELD_NAME
OPERATOR
VALUE
排序
FIELD_NAME (ASC | DESC)?
运算符
= | != | > | >= | < | <= | IN | NOT IN | LIKE | NOT LIKE | CONTAINS ANY | CONTAINS ALL | CONTAINS NONE | IS NULL | IS NOT NULL | DURING | BETWEEN | REGEXP_MATCH | NOT REGEXP_MATCH
函数
LAST_14_DAYS | LAST_30_DAYS | LAST_7_DAYS | LAST_BUSINESS_WEEK | LAST_MONTH | LAST_WEEK_MON_SUN | LAST_WEEK_SUN_SAT | THIS_MONTH | THIS_WEEK_MON_TODAY | THIS_WEEK_SUN_TODAY | TODAY | YESTERDAY
值
LITERAL | LITERAL_LIST | NUMBER | NUMBER_LIST | STRING | STRING_LIST | FUNCTION
正整数
[1-9] ([0-9])*
数字
-? [0-9]+ (. [0-9] [0-9]*)?
字符串
(' Char* ') | (" Char* ")
字面量
[a-zA-Z0-9_]*
字符串列表
( STRING (, STRING )* )
字面量列表
( LITERAL (, LITERAL )* )
数值列表
( NUMBER (, NUMBER )* )
键:
发送反馈
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可 获得了许可,并且代码示例已根据 Apache 2.0 许可 获得了许可。有关详情,请参阅 Google 开发者网站政策 。Java 是 Oracle 和/或其关联公司的注册商标。
最后更新时间 (UTC):2024-09-10。
[{
"type": "thumb-down",
"id": "missingTheInformationINeed",
"label":"没有我需要的信息"
},{
"type": "thumb-down",
"id": "tooComplicatedTooManySteps",
"label":"太复杂/步骤太多"
},{
"type": "thumb-down",
"id": "outOfDate",
"label":"内容需要更新"
},{
"type": "thumb-down",
"id": "translationIssue",
"label":"翻译问题"
},{
"type": "thumb-down",
"id": "samplesCodeIssue",
"label":"示例/代码问题"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"其他"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"易于理解"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"解决了我的问题"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"其他"
}]
需要向我们提供更多信息?
{"lastModified": "\u6700\u540e\u66f4\u65b0\u65f6\u95f4 (UTC)\uff1a2024-09-10\u3002"}
[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["没有我需要的信息","missingTheInformationINeed","thumb-down"],["太复杂/步骤太多","tooComplicatedTooManySteps","thumb-down"],["内容需要更新","outOfDate","thumb-down"],["翻译问题","translationIssue","thumb-down"],["示例/代码问题","samplesCodeIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC):2024-09-10。"]]