Hello David

Thank you for your purchase.

I can't replicate the issue on my end. Here's the table I'm querying:

And here it is filtered with a couple of conditions:

Please try this:

SELECT distancetosea, chloride, totalsulphate
FROM wpjq_wpdatatable_1
WHERE distancetosea = '0 TO 10m'
AND chloride < 200

Hi again Dave

Well, since I can't replicate the issue on my end, would you be able to provide me a temporary wp-admin user (administrator), so I can take a look?

We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third parties. 

You can write credentials here just check Private Reply so nobody can see them except us.

Thanks Dave

I don't know why it's behaving like this, but it has been forwarded to our development team, so hopefully they'll be able to figure it out soon.

Hello again Dave

For the preview it is escaping the < sign. We're not sure why, but our developers will try to resolve it for the next update. If they don't have time to include it in the next update, it will be included in the one after that 100%.