mysql: LIKE — поиск без учета регистра

SELECT * FROM tablename WHERE UPPER(fieldname) LIKE UPPER('%searchvalue%');