mysql WHERE statement


  Translation results:

英[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 statementsyntax

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 statementexample

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

Popular Recommendations

Home

Videos

Q&A