Home> Database> SQL> body text

What is pointed out by using where clause in sql query

Release: 2019-07-24 10:15:23
Original
15761 people have browsed it

What is pointed out by using where clause in sql query

Using the where clause in a sql query indicates the query conditions.

SQL WHERE clause
The WHERE clause is used to extract those records that meet the specified criteria.

SQL WHERE syntax

SELECT column_name,column_name FROM table_name WHERE column_name operator value;
Copy after login

Operators in the WHERE clause

The following operators can be used in the WHERE clause Used in:

Operator Description
= is equal to
<> is not equal to.Note:In some versions of SQL, this operator can be written as !=
> is greater than
< is less than
>= is greater than or equal to
<= Less than or equal to
BETWEEN Within a certain range
LIKE Search for a pattern
IN Specify multiple possible values for a column

Recommended: "SQL Video Tutorial"

The above is the detailed content of What is pointed out by using where clause in sql query. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!