{"post":"

WHERE CLAUSE:

The ‘Where’ Clause is the most treasured conditional statement in MySQL according to me. In due course of experience, you will know that the most used condition will be under the syntax of ‘Where’ Clause.

The General Syntax is:

SELECT column1, column2, …\nFROM table_name
\nWHERE columnN  condition;

Let us try to obtain the details of Students who failed in the class having ‘F’ grade and some more conditions subsequently.

There is a series of Queries on the use of WHERE Clause that will make you understand the concept crystal clear!

SELECT name,marks,grade,mobile\nFROM school\nWHERE grade = “F”;

$\"\"$

SELECT  roll, name,marks\nFROM school\nWHERE marks>80;

$\"\"$

SELECT state,govt,population\nFROM country\nWHERE population>100000000;

$\"\"$

SELECT product, name, quantity\nFROM store\nWHERE exp<curdate();

$\"\"$

SELECT product, name, exp\nFROM store\nWHERE price>1000;

$\"\"$

SELECT * \nFROM railways\nWHERE train_no = 12437;

$\"\"$

SELECT train_no, train_name, costperkm\nFROM railways\nWHERE costperkm<100;

$\"\"$

SELECT service_no, name, ranks, unit\nFROM air_force\nWHERE service_no<800000;

$\"\"$

LIKE CLAUSE:

The ganeral Syntax is

SELECT column1, column2, …\nFROM table_name
\nWHERE columnN LIKE pattern;

The LIKE Clause has two important operators namely, ‘%’ and ‘_’ where % represents any number of characters including zero or one but _ represents only one character.

The LIKE Clause is mainly designed for string matching and comparison and all the names you have can be manipulated using the LIKE Clause.

SELECT state, capital, govt\nFROM country\nWHERE govt LIKE ”%BJP%”;

$\"\"$

If there is a special need of finding the Products of a Store which starts with the letter ‘S’, then this can be achieved by the following Query:

SELECT product, name\nFROM store\nWHERE name LIKE “S%”;

$\"\"$

If there is a need of finding a String that has a particular number of Characters from the Column. In fact, all the specific pattern can be obtained from the use of these two operators.

Let’s imagine the teachers wants to know which students have 5 letters in their name.

SELECT roll, name\nFROM school\nWHERE name LIKE “_____”;

//5 underscores

$\"\"$

The former Query shows a result of Empty set because there is no such name in the Name List whose name is like that format, if the name like “n a m e” was present, the query would have shown that.

But, the LIKE Clause doesn’t get restricted to Strings as well. The Integers can also be compared using that. If you want to check a 3-digit Quantity in the Store list, then the following Query would help:

SELECT *\nFROM store\nWHERE quantity LIKE \"___\";

//3 underscores

$\"\"$

Conclusion:

This segment will relate you to the actual implementations of the Operators and the 2 Clauses. You may feel the way how you can filter the results in Net when the user gives a specific condition. How to show the correct results where the user starts typing the actual word and much more!

\n","title":"Where & Like Clause","authorDetails":{"name":"Soumya Shaw","slug":"soumya-shaw"},"seo":{"title":"Where & Like Clause in SQL"},"description":"‘Where’ Clause is the most treasured conditional statement in MySQL, you will know that the most used condition will be under the syntax of ‘Where’ Clause.","slug":"sql/where-like-clause-in-sql/","articleId":"636a83487bb1ce5072622c4a","bookmarkStatus":{"isBookmarked":false,"bookmarkId":null}}