WHERE IS NUMERIC equivalent?

[law...@gmail.com]

Hello -

I was looking for something like 'WHERE field IS NUMERIC', ala 'WHERE
field IS NULL' .

I have an ENUM field that can be 1,2,3,4,5 or 'N/A'. I would like to
do a SUM(answer) WHERE answer IS NUMERIC, so as to exclude the N/A
from the summing of the answers.

What's the best way to do this? A regex in the where clause?

[Rik Wasmus]

Euhm, WHERE field != 'N/A' would be the way to go in the case you describe.
--
Rik Wasmus