MySQL REGEX Query

[BamaStangGuy]

I am running this query:

PHP Code:

        $result_date = $vbulletin->db->query_read("
                        SELECT DISTINCT
                        z.tag, COUNT(*) AS total_lyrics
                        FROM " . TABLE_PREFIX . "zoints_tag AS z
                        LEFT OUTER JOIN " . TABLE_PREFIX . "thread AS t
                        ON z.threadid = t.threadid
                        WHERE t.forumid = 34 AND z.tag REGEXP '^[0-9]'
                        GROUP BY z.tag
                        ORDER BY z.tag
        "); 


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?

[Marco van Herwaarden]

'^[0-9]'

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

try:

'^[0-9].*'

[BamaStangGuy]

I figured it out. I had a misspelling lol.

Thanks for the help though, I did need to adjust the regex.