WHERE

[php.ajax.coder]

I need to have a which returns the number of words which don't start with A-Z

 

SELECT COUNT(*) FROM Dictionary WHERE Word LIKE 'A%'

 

Other than saying NOT 'A%' AND NOT 'B%' etc....

 

is there a simple way of doing this

 

Thanks

[corbin]

You could use MySQL's REGEXP feature.  (I think the keyword for regular expression match [regexp] is REGEXP.)

 

 

Aside from that, I don't know if it's possible.