MySQL Comparison Operators

This post is labeled under Software Development

This is the continuation of Laboratory Activity 2. I suggest that you do the said lab activity first (if you haven't done so) before proceeding on this activity. You may visit it here.

Comparison operators in MySQL are used parallel with WHERE clause to limit records or row selections. Relational operators such as ,less than, less than equal, equal, not equal, greater than, greater than equal ( <, <=, =,!=, >, >= ) are used to filter out rows depending on criteria set.

On this exercise (see below attached text), the use of IN, NOT, LIKE, GROUP BY, HAVING is also introduced as we expand our SELECT statement criterion.

MySQL Activity 3

Activity 4 of this MySQL Tutorial series will present connection of tables within the MySQL Database and establishing its relationship.