link Speed up your Web App by 1000% with 1 Line of SQL SELECT * FROM table WHERE lower(fieldname) LIKE ‘abc%’;