DBA tips & tricks: SQL’s version of JS’s callback hell. Substituting OR for IN.

What is OR good for? Absolutely nothing!

SELECT * FROM Meals WHERE Food = 'APPLE' OR Food = 'ORANGE' OR Food = 'BREAD' OR Food = 'ALT MILK' OR Food = 'POTATOE' OR Food = 'CAKE'

“IN” has entered the chat

SELECT * FROM Meals WHERE Food IN ('APPLE', 'ORANGE', 'BREAD', 'ALT MILK', 'POTATOE', 'CAKE');

--

--

--

Developer (CRM/ERP/Process management software) C#.NET JavaScript & honestly whatever will get the job done!

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Stack implementation using Swift.

Top Kubernetes Security Best Practices You Should Know

•twins• . . Done at @polifamous_tattoo_atelier Using @water_law_tattoo butter an…

Privacy-Preserving Computational Biology using Yao protocol

VLOOKUP in 5 languages (VBA/SQL/PYTHON/M query/DAX powerBI)

Beautiful Days at the Movies

Mobile Development Weekly Issue 20

10-Minute Guide to Git Version Control for Testers

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Philip Pol

Philip Pol

Developer (CRM/ERP/Process management software) C#.NET JavaScript & honestly whatever will get the job done!

More from Medium

Starting with Git and Github

5 bad coding habits you need to put an end to right now

HOW TO WRITE EFFICIENT CODE

Let’s Understand Some OOP ( Object Oriented Programming ) terms easily.