Question: what is the difference between like and equal to in sql?
Answer: LIKE is generally used only with strings and equals (=) is used for exact matching and it seems faster. The underscore character ( _ ) represents a single character to match a pattern from a word or string. More than one ( _ ) underscore characters can be used to match a pattern of multiple characters.