Difference between ‘LIKE’ and ‘IN’ in meta queries

Meta queries are essentially wrapper for ease of setup, but end results is part of SQL query to run on MySQL database.

These operators are those of MySQL, see in documentation:

• LIKE operator (performs pattern matching)
• IN() function (checks if value is in set)