Support case-insensitive when select where

[mzgs9988]

Enhancement

I'm using Realtime synchronization from MySQL，when i query with sql: select * from xxx where name like '%a%' on mysql，the result returned name with 'aAa', case-insensitive，but when i query in starrocks，the result is empty, case-sensitive，how can i resolve this problem？Thank you !
starrocks version: 3.0

[xyan3880]

mysql uses collation/charset of the value/column for case sensitivity .

Unfortunately I don't think starrocks supports it now, so you can try "ilike()" function, which is undocumented so far.