Filter Database Query

Have setup database query which displays all the data in mySQL database. The page contains an input filter.
When I change the Conditions in the query builder to contains (or begins with, doesn’t contain, ends with, etc.) the filter appears not to work as the page continues to display all the records. However, when I change the Conditions to equal, not equal, in, not, in, is empty, etc. the filter works, returning only the records according to the filter inputs.
Not sure how to fix this. Any help much appreciated.
Thanks
Postmast

Community Page
Last updated: