Comparison operators in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the '=' operator do in SQL?

The '=' operator checks if two values are equal. It returns true if they are the same, false otherwise.

beginner

What is the difference between '<>' and '!=' in MySQL?

Both '<>' and '!=' mean 'not equal to' in MySQL. They work the same way and can be used interchangeably.

beginner

How does the '>' operator work in SQL?

The '>' operator checks if the value on the left is greater than the value on the right. It returns true if yes, false otherwise.

beginner

What does the '<=' operator mean in SQL?

The '<=' operator means 'less than or equal to'. It returns true if the left value is smaller or equal to the right value.

intermediate

Can you use comparison operators with text (strings) in MySQL?

Yes, you can compare strings using comparison operators like '=', '<>', '>', '<'. MySQL compares strings based on alphabetical order.

Which operator checks if two values are NOT equal in MySQL?

A =

B <>

C >=

D <

The '<>' operator means 'not equal to' in MySQL.

What will the expression '5 > 3' return in SQL?

A True

B False

C Error

D Null

5 is greater than 3, so '5 > 3' returns true.

Which operator means 'less than or equal to'?

A >=

B <=

C !=

D =

'<=' means less than or equal to.

If you want to check if two values are exactly equal, which operator do you use?

A <>

B !=

C =

D >

'=' checks if two values are equal.

Can you use '>' to compare two text strings in MySQL?

A Yes, based on alphabetical order

B No, only numbers

C Only dates

D Only boolean values

MySQL compares strings alphabetically using comparison operators.

Explain how the '=' and '<>' operators work in MySQL with examples.

Think about checking if two values are the same or different.

Describe how comparison operators like '>', '<=', and '!=' can be used in SQL queries.

Imagine filtering data based on conditions.