What the different between IN , AND (MY SQL)

Question

Hello , my question is what the different between ( IN , AND ) In the (mysql) .

Answer 1

AND is to combine 2 or more queries or just like to test multiple conditions in a query...and OR is to compare a column with more then 1 value.
in otherway,
IN is used to check whether the wanted data is present or not its same like OR ....and AND is same as logical && like,if all the values or the data is true then only the condition within the paranthesis after that will be obtained as output