[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
www.r2communications.com



More information about the thelist mailing list