SELECT * FROM table WHERE lower(fieldname) LIKE ‘abc%’;