v.23.3New Feature
Add INSTR as alias of positionCaseInsensitive for MySQL compatibility
AddINSTRas alias ofpositionCaseInsensitivefor MySQL compatibility. Closes #47529. #47535 (flynn).
Why it matters
Enables users migrating from MySQL or working in mixed environments to use the familiarINSTR function for case-insensitive substring searches, improving query compatibility and easing transition.How to use it
Use theINSTR function in your SQL queries as a case-insensitive substring search, similar to positionCaseInsensitive. For example:SELECT INSTR('Hello World', 'world');This will return the position of the substring ignoring case.