WHERE Clause With Comparison Operators
Query:
SELECT * FROM employees WHERE first_name = 'John';
This query will retrieve employess with first name john
Output:
Query:
SELECT * FROM employees WHERE salary <> 60000;
This query will retrieve employees with salary not equal to 6000
Output:
WHERE Clause in MariaDB
MariaDB uses SQL (Structured Query Language) and it is an open-source relational database management system (RDBMS) for managing and manipulating data. The WHERE clause in SQL queries is used to filter and obtain specific data. The ability to remove and retrieve specific data using the WHERE clause in SQL queries is one of the main features that makes MariaDB robust. This article will examine the syntax and many uses for the WHERE clause in MariaDB.