On Sat, 27 Oct 2007 21:48:27 +0200, <182719@rock.com> wrote:

> Hi, I have this huge database of millions of records ... mixed in are
> dozens and dozens, maybe hundreds of entries that are in all or mostly
> uppercase. I do not want to lowercase them, or delete them.... just
> ID them so they can be normalized. Is there any method to search
> across a table for instances where more than 1 consecutive letter is
> simply uppercase?
>
> like
>
> THE dog jumped over
> THe dog jumped over
> The DOg jumped over
>
> .... all would be noticed .... can this be done or is this beyond the
> capability of a query search?

SELECT fieldname
FROM test
WHERE fieldname REGEXP BINARY '[[:upper:]]{2,}';
--
Rik Wasmus