|
One think I am looking at here:
What I am looking for:
norther arizona
What I am getting returned, but not wanted:
north carolina
select * from testit where name rlike 'nort.*ar.*'
how can specify the "ar" is to start the word. ^ only does the start of the string right? my query:
select * from testit where name rlike 'nort.*^ar.*'
returns nothing.
__________________
I do stuff - aIm CS_Jay_D
|