Combining Conditions
This lesson discusses how to combine multiple conditions in a MySQL query.
We'll cover the following
Combining Conditions
In this lesson we’ll learn how to combine multiple conditions in the WHERE clause.
Example Syntax
SELECT col1, col2, … coln
FROM table
WHERE col3 LIKE "%some-string%"
AND
col4 = 55;
Connect to the terminal below by clicking in the widget. Once connected, the command line prompt will show up. Enter or copy and paste the command ./DataJek/Lessons/10lesson.sh and wait for the MySQL prompt to start-up.
Level up your interview prep. Join Educative to access 80+ hands-on prep courses.