Hi,

I have a suggestion for the MySQL dialect.

When you perform a query by example, case insensitively and matchmode = start it results in the SQL code for MySQL:

"lower(DB_Field) like ?"

This syntax means MySQL doesn't use any index there might be on DB_Field.

As it turns out, in MySQL executing "DB_Field like ?" is also case insensitive,

so in the special case of :
SQL Dialect = MySQL
Query By Example
Case Insensitive
MatchMode = (anything that results in 'like')

the lower call can be dropped.