or operator in sql

1Used alongside WHERE to include data when either condition is true.
2Example: Returns users that live in either Sheffield or Manchester.
3SELECT * FROM users
4WHERE city = 'Sheffield' OR 'Manchester';

1/* AND is a operator that allows you to combine two conditions
2Both conditions must be true for the row to b e included in the result set */
3SELECT column_name(s)
4FROM table_name
5WHERE column_1 = value_1
6AND column_2 = value_2;

1Used to join separate conditions within a WHERE clause.
2Example: Returns events located in London, United Kingdom
3SELECT * FROM events
4WHERE host_country='United Kingdom' AND host_
5city='London';

1(IN) operator in sql like "OR" operator
2For example: 
3Select * From employees
4Where department_id "IN" (60,90); 
5

1LOGICAL OPERATORS?
2ALL	    (TRUE if all of the subquery values meet the condition)	
3AND	    (TRUE if all the conditions separated by AND is TRUE)	
4ANY	    (TRUE if any of the subquery values meet the condition)	
5BETWEEN	(TRUE if the operand is within the range of comparisons)	
6EXISTS	(TRUE if the subquery returns one or more records)
7IN	    TRUE if the operand is equal to one of a list of expressions)	
8LIKE	(TRUE if the operand matches a pattern)	
9NOT	    (Displays a record if the condition(s) is NOT TRUE)	
10OR	    (TRUE if any of the conditions separated by OR is TRUE)	
11SOME	(TRUE if any of the subquery values meet the condition)

1
2SELECT column1, column2, ...
3
4FROM table_name
5
6WHERE condition1 OR condition2 OR condition3 ...;