Equal To and Not Equal To

Equal To (=) checks whether the values of the two fields are equal or not. If it matches, then the condition becomes true and fetches for further processing. If it doesn't match, then condition should be Not Equal which would revert the way of Equal To. It would fetch data based on the condition that doesn't match.

For example, the following query is used to retrieve all records with the city matching New York:

SELECT * FROM `users` WHERE `city` = 'New York';