On 12/18/05, Andy Pieters <[EMAIL PROTECTED]> wrote: > > Is there any operator for mysql that behaves like "LIKE" but can act on > numbers.
No. But with a bit of creativity you can use arithmetic to come to a predictae that does the same: SELECT * FROM table WHERE floor(log10(floor(x / y))) <> floor(log10(floor(x / (y + 1)))) (You might want to verify that this works as intended, including NULL's, 0's and negatives.) Jochem
