Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 28 Oct 2007, 08:49
BamaStangGuy's Avatar
BamaStangGuy BamaStangGuy is offline
 
Join Date: Mar 2004
Real name: Brent Wilson
MySQL REGEX Query

I am running this query:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

With the goal of retrieving every tag that starts with 0-9. I have one tag in there right now that starts with a 3, '3 doors down'.

However the above query does not return any results. Is that the correct format and if so what would be causing it to return nothing at all?
__________________
The Discussion Network
Reply With Quote
  #2  
Old 28 Oct 2007, 13:03
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
'^[0-9]'

This means that the data should start with a single digit number and nothing after that.

try:

'^[0-9].*'
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #3  
Old 28 Oct 2007, 19:50
BamaStangGuy's Avatar
BamaStangGuy BamaStangGuy is offline
 
Join Date: Mar 2004
Real name: Brent Wilson
I figured it out. I had a misspelling lol.

Thanks for the help though, I did need to adjust the regex.
__________________
The Discussion Network

Last edited by BamaStangGuy : 28 Oct 2007 at 20:47.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 02:39.

Layout Options | Width: Wide Color: