[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