SQL

Recommended Readings

Item
Links
Documentation / Tutorials
Industry / Case-studies
    ​
Books
    ​
1
select
2
from
3
where
4
order by [desc]
Copied!

Google Sheets

​Multiple contains ​

1
=QUERY(A1:A,"Select * Where not A Matches '.*AB.*|.*DJ.*' ",1)
2
=query(C323:C335,"Select C where not C contains 'soccer'")
3
=QUERY(C:C,"Select C Where not C Matches '.*ezoic.*|.*soccer.*' ",1)
4
​
Copied!

Referencing cells in query

1
query(sheet2!A:G,"select A where G contains '"&L3&"'")
2
​
3
=query(SX_Sessions!$B$2:$E$120,
4
"select B,D
5
where E ='" &B3&"'
6
AND C = '"&$B$1&"'")
Copied!
1
=IMPORTXML(B3, "//a/@href")
Copied!
Last modified 1yr ago