Character Count... and More.

[kmarsh]

I need to do this in pure MySQL (if I can).

What I'm looking to do is limit my query like this:

• At least five \n's (newlines) with 10 - 30 character's per line.

Does that make sense? I know PHP can do this, but can MySQL?

[kmarsh]

Doh! I bet you could use Regular Expressions, but hmm, how?

Vincent? 🙂

[[deleted]]

something like

select if (field REGEXP "([a-zA-Z0-9 ]{10,30}\n){5,}",'yes','no');

You'll have to change the pattern to allow punctuationmarks etc...