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.