multiSearchFirstIndexCaseInsensitiveUTF8 Returns the indexi(starting from 1) of the leftmost found needleiin the stringhaystackand 0 otherwise. Assumeshaystackandneedleare UTF-8 encoded strings. Ignores case. Syntax multiSearchFirstIndexCaseInsensitiveUTF8(haystack, [needle1, needle2, ..., needl...
You can create a case-insensitive index withdb.collection.createIndex()by specifying thecollationoption: db.collection.createIndex( { <field>: <sortOrder> }, { collation: { locale: <locale>, strength:<1|2> } } ) To specify a collation for a case-insensitive index, include the following...
Multi index SQLLIKE Type of quoting " ' Inclusion Yes Yes Exclusion Yes No Enumeration Yes No One char pattern No _ Multi char pattern * % Escaping No ESCAPE Which one to use, is up to you however try to stick to the same one across your queries for consistency. ...