Entering a criteria in the query GUI using NOT LIKE: if a criteria such as: not like '*a*' is entered in the gui interface, quotes get put around the whole expression after it is entered. e.g. 'not like '*a*'' It can be edited in the SQL view and it will work, but when going back to the gui view, a syntax error message appears. Using LIKE by itself in a criteria works okay. This error did not occur in the 4.1.x versions of LibreOffice, but did start in the 4.2.x versions.
*** This bug has been marked as a duplicate of bug 82427 ***