mysql OR operator
Translation results：
英[ɔ:(r)] 美[ɔr] ifier or] ʿ …Before, earlier than…
n.[Heraldry]Black gold, black
mysql OR operatorsyntax
Function: Combine two or more conditions in the WHERE substatement.
Syntax: SELECT * FROM table name WHERE field 1 operator value OR field 2 operator value
Description: If the first condition As long as one of the two conditions is true, the OR operator displays a record.
mysql OR operatorexample
//使用 OR 来显示所有姓为 "Carter" 或者名为 "Thomas" 的人 SELECT * FROM Persons WHERE firstname='Thomas' OR lastname='Carter';