mysql WHERE statement

英[weə(r)] 美[wer]

adv.Where, where; to where; a certain situation or position

conj.In the place of...

n. Place, place

pron.Where

Plural: wheres

mysql WHERE statement syntax

Function:If you need to conditionally select data from the table, you can add the WHERE clause to the SELECT statement.

Syntax:SELECT column name FROM table name WHERE column operator value

Description:= equal to, <> not equal to, > ; Greater than, < Less than, >= Greater than or equal to, <= Less than or equal to, BETWEEN Within a certain range, LIKE Search for a certain pattern.

Note:In some versions of SQL, the operator <> can be written as !=.

mysql WHERE statement example

//选取居住在城市 "Beijing" 中的人 SELECT * FROM Persons WHERE City='Beijing';