Mantieni tutto organizzato con le raccolte
Salva e classifica i contenuti in base alle tue preferenze.
Il linguaggio di query di Google Ads ti consente di filtrare il set di dati restituito con una serie di operatori diversi. Quando filtri in base ai valori stringa, la sensibilità
alle maiuscole e minuscole predefinita di ogni operatore svolge un ruolo importante
nel filtrare correttamente i risultati.
[null,null,["Ultimo aggiornamento 2025-08-27 UTC."],[[["\u003cp\u003eThe Google Ads Query Language uses operators like \u003ccode\u003e=\u003c/code\u003e, \u003ccode\u003e!=\u003c/code\u003e, \u003ccode\u003eIN\u003c/code\u003e, \u003ccode\u003eNOT IN\u003c/code\u003e, \u003ccode\u003eLIKE\u003c/code\u003e, \u003ccode\u003eNOT LIKE\u003c/code\u003e, \u003ccode\u003eCONTAINS\u003c/code\u003e, \u003ccode\u003eREGEXP_MATCH\u003c/code\u003e, and \u003ccode\u003eNOT REGEXP_MATCH\u003c/code\u003e to filter data.\u003c/p\u003e\n"],["\u003cp\u003eOperators like \u003ccode\u003e=\u003c/code\u003e, \u003ccode\u003e!=\u003c/code\u003e, \u003ccode\u003eIN\u003c/code\u003e, \u003ccode\u003eNOT IN\u003c/code\u003e, and \u003ccode\u003eCONTAINS\u003c/code\u003e are case-sensitive when filtering string values, while \u003ccode\u003eLIKE\u003c/code\u003e and \u003ccode\u003eNOT LIKE\u003c/code\u003e are case-insensitive.\u003c/p\u003e\n"],["\u003cp\u003e\u003ccode\u003eREGEXP_MATCH\u003c/code\u003e and \u003ccode\u003eNOT REGEXP_MATCH\u003c/code\u003e are case-sensitive by default but can be made case-insensitive using \u003ccode\u003e(?i)\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,["# Case Sensitivity\n\nThe Google Ads Query Language lets you filter the returned data set with a number of\ndifferent operators. When filtering on string values, the default case\nsensitivity of each operator will play an important part in correctly\nfiltering your results.\n\n| Operators | Case Sensitivity |\n|----------------|------------------|\n| = or != | Case sensitive |\n| (NOT) IN | Case sensitive |\n| (NOT) LIKE | Case insensitive |\n| CONTAINS (...) | Case sensitive |\n| REGEXP_MATCH | Optionally Both |\n\n**Key Point:** `REGEXP_MATCH` and `NOT REGEXP_MATCH` are case sensitive by default, but you can include `(?i)` to make them case insensitive. Example: \n\n SELECT campaign.id\n FROM campaign\n WHERE campaign.name REGEXP_MATCH \"(?i).*test.*\""]]
