提供意見
查詢文法參考資料
透過集合功能整理內容
你可以依據偏好儲存及分類內容。
下表包含完整的 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 )* )
索引鍵:
提供意見
除非另有註明,否則本頁面中的內容是採用創用 CC 姓名標示 4.0 授權 ,程式碼範例則為阿帕契 2.0 授權 。詳情請參閱《Google Developers 網站政策 》。Java 是 Oracle 和/或其關聯企業的註冊商標。
上次更新時間: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": "\u4e0a\u6b21\u66f4\u65b0\u6642\u9593\uff1a2024-09-10 (\u4e16\u754c\u6a19\u6e96\u6642\u9593)\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"]],["上次更新時間:2024-09-10 (世界標準時間)。"]]