IT> LIKE is case-insensitive by default. To have it use your index, you need IT> to either make the index case-insensitive:
Thanks! It's clear now. IT> What's the point of using LIKE if you don't have any wildcards in the IT> pattern? Actually I do have wildcards, this was just a test, my actual query is: var statement = connection.createStatement("SELECT * FROM addressBook WHERE name LIKE ?1 OR email LIKE ?1"); statement.bindString(statement, 0, text + "%"); telega) ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------