Description\n-----------\n\nTests whether _expr_ matches the pattern _pat_. Returns either 1 (TRUE) or 0 (FALSE).\\\nBoth _expr_ and _pat_ may be any valid expression and are evaluated to strings.\\\nPatterns may use the following wildcard characters:\n\n % matches any number of characters, including zero.\n _ matches any single character.\n\nUse NOT LIKE to test if a string does not match a pattern. This is equivalent to using\\\nthe NOT operator on the entire LIKE expression.\n\nIf either the expression or the pattern is NULL, the result is NULL.\n\nLIKE performs case-insensitive substring matches if the collation for the expression and pattern is case-insensitive. For case-sensitive matches, declare either argument to use a binary collation using collate, or coerce either of them to a BINARY string using CAST. Use SHOW COLLATION to get a list of\\\navailable collations. Collations ending in _bin are case-sensitive.\n\nNumeric arguments are coerced to binary strings.\n\nThe _ wildcard matches a single character, not byte. It will only match a multi-byte character\\\nif it is valid in the expression's character set. For example, _ will match _utf8"€", but it\\\nwill not match _latin1"€" because the Euro sign is not a valid latin1 character. If necessary,\\\nuse CONVERT to use the expression in a different character set.\n\nIf you need to match the characters _ or %, you must escape them. By default, you can prefix the wildcard characters the backslash character \\ to escape them. The backslash is used both to encode special characters like newlines when a string is parsed as well as to escape wildcards in a pattern after parsing. Thus, to match an actual backslash, you sometimes need to double-escape it as "\\\\\\\\".\n\nTo avoid difficulties with the backslash character, you can change the wildcard escape character using ESCAPE in a LIKE expression. The argument to ESCAPE must be a single-character string.\n\nExamples\n--------\n\nCREATE TABLE t1 (d VARCHAR(16));\nINSERT INTO t1 VALUES \n  ("Monday"), ("Tuesday"), ("Wednesday"), \n  ("Thursday"), ("Friday"), ("Saturday"), ("Sunday");\nSELECT * FROM t1 WHERE d LIKE "T%";\n\nURL: https://mariadb.com/docs/server/reference/sql-functions/string-functions/like