sql like multiple values code example

Example 1: sql where multiple values

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);

Example 2: multiple like in sql

SELECT * FROM my_table WHERE (colA LIKE '%hello%' OR colB LIKE '%world%');