What is the difference between AND and OR operators in mySQL code example

Example: operator in mysql

SELECT * FROM `tableName` WHERE `ColumnName` IN (1,2,3);