In most languages that use it, it represents the modulus operation.

In APEX, you use Math.Mod()

if (Math.Mod(x, 2) == 0) {
    system.debug(x + ' is even');
}

APEX Expression Operators Reference shows that there is no definition of a % operator.

As of Spring 19 (and all prior versions), we only have mod(Integer, Integer) and mod(Long, Long). There is no known information of when, or if, we might get a built in for Decimal or Double values.

SOQL won't let you do any calculations. Check docs here and here:

You must supply a native value—other field names or calculations are not permitted

Generally speaking it's fieldName = value or datefieldname > YESTERDAY (few special literals for date handling).

Easiest would be to create a formula field in the record (think about them like calculated columns in views in normal databases) with your logic. It could be of text type, call it "weird price" ;) Here's the complete formula functions reference - you have MOD(), IF(condition, true, false) etc goodies.

The only caveat is that you can't GROUP BY formula (there also tricks to bypass that ;))

So yeah - if it's one time thing with poor reusability - filter with code. If you can accept the low cost (formulas don't use storage but you might need them for other purposes) - create a field.