[thelist] MySQL REGEXP Help

Randal Rust randalrust at gmail.com
Thu Feb 14 17:56:48 CST 2008

Calling Rudy:)

Let's say I have a sentence like this:

The cow jumped over the moon.The dish ran away with the spoon.

I need to run through all of my records and find the ones where there
is no space between the period and the next letter.

I was trying this...

select entryID, linkTitle from entries where narrative REGEXP
'^[/.][a-zA-Z]*' order by entryID asc

...but it gives me all of the records. So obviously it's not correct.
I'm not quite following the REGEXP examples at MySQL.org.

Randal Rust
R.Squared Communications

More information about the thelist mailing list