Question: how like works in mysql?
Answer: In MySQL, the LIKE operator performs pattern matching using an SQL pattern. If the string matches the pattern provided, the result is 1 , otherwise it's 0 . The pattern doesn't necessarily need to be a literal string. This function can be used with string expressions and table columns.