The MySQL OR operator is used to displays a record if any one of the condition is TRUE to get the records as result. In other hand, MySQL OR operator is filter record if any of the conditions separated by OR is TRUE.
To filter a record if any of the conditions separated by OR
is TRUE, use the following syntax:
Parameters:
tablename: The table name from which you want to fetch the records.
condition: To specifies multiple conditions, either of the condition must be true to select records.
OR
is TRUE:
Note:
In the above example, we are showing how to use the OR
operator to filter records based on any of the conditions separated by OR
is TRUE SELECT
statement.
You can use MySQL Command Line Client to filter records based on any of the conditions separated by OR
is TRUE. It will look like this: