Clarify that pattern matching with LIKE operator is case insensitive for SQLite and MySQL

[shaileshaanand]

The Drizzle ORM docs specify that LIKE operator is "case sensitive" for SQLite, MySQL and PostgreSQL databases at https://orm.drizzle.team/docs/operators#like

But actually the LIKE operator is only case sensitive for PostgreSQL[1] and is case insensitive for SQLite[2] and MySQL[3] databases.

I have tested SQLite with bun-sqlite driver and can confirm that the LIKE filter returns case insensitive results for me.

File to be edited:

drizzle-orm-docs/src/content/documentation/docs/operators.mdx

Line 348 in b4fb88d

Value is like other value, case sensitive

[1] https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-LIKE
[2] https://www.sqlite.org/lang_expr.html
[3] https://dev.mysql.com/doc/refman/8.0/en/pattern-matching.html

Screenshots:

PostgresQL:

SQLite:

MySQL: