not in vs not like

Hi Goodness Abija!

Thanks for reaching out!

Typically, NOT LIKE is used to filter out rows that match a specific string pattern, while NOT IN - to eliminate rows that correspond to certain values or the outcomes of a subquery. While NOT IN works with any data types, NOT LIKE is specifically used for string comparisons.

Hope this helps.

Best,

Ivan