NoSleepCreative Wiki
Tutorials
Instagram
My works
Search…
Welcome to NoSleepCreative
After Effects
Getting Started with Expressions
Expressions & Snippets
Cookbook
Getting started with Scripting
Scripting
ScriptUI
Motion Design
Getting Started with After Effects
Animation Principles
Cinema 4D
Code
Houdini
C++
Shader Dev
Python
REGEX
Google Sheets Formulas
Terminal
SQL
Webscraping
CSS
TensorFlow
Mathematics
Software & Tutorials
Photoshop Automation
Elementor
Premiere Pro
Illustrator
InDesign
Blender
Mac Superuser
archive
Thought Catalog
Art school
😄
About me
🔴
Things I learned
How to get better
Recommended books
Discussion topics
Powered By
GitBook
SQL
Recommended Readings
Item
Links
Documentation / Tutorials
​
SQL for Beginners
​
​
Management Information Systems Careers
​
Industry / Case-studies
​
Books
​
Cheatsheet
​
​
https://www.sqltutorial.org/sql-cheat-sheet/
​
Luke Harrison:
https://websitesetup.org/sql-cheat-sheet/
​
select
from
where
order by [desc]
Google Sheets
​
Multiple contains
​
=QUERY(A1:A,"Select * Where not A Matches '.*AB.*|.*DJ.*' ",1)
=query(C323:C335,"Select C where not C contains 'soccer'")
=QUERY(C:C,"Select C Where not C Matches '.*ezoic.*|.*soccer.*' ",1)
​
Referencing cells in query
query(sheet2!A:G,"select A where G contains '"&L3&"'")
​
=query(SX_Sessions!$B$2:$E$120,
"select B,D
where E ='" &B3&"'
AND C = '"&$B$1&"'")
Hyperlinks
=IMPORTXML(B3, "//a/@href")
Code - Previous
Terminal
Next - Code
Webscraping
Last modified
2yr ago
Copy link
Outline
Recommended Readings
Google Sheets
Multiple contains
Referencing cells in query
Hyperlinks