Useful HSQLDB Commands
Search for a string ignoring case,
select * from TABLE_X where LCASE(FIELD_X) like '%superman%';