ilike substitute for mysql
hi, is it possible to do case insensitive like in mysql using drizzle?
doing like(sql’lower(${table.column})’, value.toLowerCase()) is giving me an error like in the attached screenshot
i also found some resource that suggests adding COLLATE UTF8_GENERAL_CI column definition, maybe that’s how i should be doing it?
any help is appreciated!
doing like(sql’lower(${table.column})’, value.toLowerCase()) is giving me an error like in the attached screenshot
i also found some resource that suggests adding COLLATE UTF8_GENERAL_CI column definition, maybe that’s how i should be doing it?
any help is appreciated!
