Hi @baris35,
a typical way to compare case insensitive is both sides e.g. to convert to lowercase:
update tbl set col = foo where lower(col) rlike 'canal panda;
Here the right hand side must be lowercase.
Note the (big) difference between wildcards % and regexes. Here, canal panda is a regex, but a very simple one, without any special chars like *or [] etc. See e.g. https://dev.mysql.com/doc/refman/8.0/en/pattern-matching.html.