LIKE Operator
In SQL, the LIKE operator is used in the WHERE clause to search for a specified pattern in a column.
- % – It is used for zero or more than one character.
- _ – It is used for only one character means fixed length.
Query
SELECT * FROM employee WHERE emp_city LIKE 'P%';
Output
SQL – Logical Operators
SQL logical operators are used to test for the truth of the condition. A logical operator like the Comparison operator returns a boolean value of TRUE, FALSE, or UNKNOWN. In this article, we will discuss different types of Logical Operators.
Logical operators are used to combine or manipulate the conditions given in a query to retrieve or manipulate data .there are some logical operators in SQL like OR, AND etc.
Contact Us