In LIKE  matching, ‘%’ indicates matching any multiple characters. The ‘_’ indicates matching a single character. To match ‘%’ or ‘_’ itself, you must escape it. The ‘\%’ matches the character ‘%’ and  ‘\_’ matches the character ‘_’.
    'abcd' like 'ab%' -- true
    'abcd' like 'ab\%' -- false
    'ab%cd' like 'ab\\%%' -- true
Notice
MaxCompute SQL only supports the UTF-8 character set. If the data is encoded in another format, it is possible that the calculation result is not correct.