Question: what is the difference between like and = in sql?
Answer: = is a comparison operator that operates on numbers and strings. When comparing strings, the comparison operator compares whole strings. LIKE is a string operator that compares character by character. To complicate matters, both operators use a collation which can have important effects on the result of the comparison.