Using reg ex in PHP to query MYSQL

Question

I am trying to query a MYSQL database using regular expressions. I am looking to get the values under columns with this pattern 1234X32X12.

I have written some pseudo-code, but I am unfamiliar with regular expressions, so I was hoping someone could help me out.

CODE:

if ($transposed_array[$i][0] starts with number)
    {
        $sid = regex something /^[0-9]*/
        $gid = regex something /X[0-9]*X/
        $gid = remove first and last character from $gid
        $qid = regex something /[0-9]*$/

        $question_text = mysql_query("select question from table where sid = ".$sid." and gid = ".$gid." and qid = ".$qid." limit 1");
        $transposed_array[$i][0] = $question_test
    }

Any help would be appreciated!

che · Accepted Answer · 2012-10-25 18:40:35Z

1

MySQL supports regex matching directly in its SQL commands, check out its manual:

select col from table where col regexp '^h';

(see this at sqlfiddle)

answered Oct 25, 2012 at 18:40

che

12.3k7 gold badges47 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Lars · Accepted Answer · 2012-10-25 18:41:34Z

0

I would suggest to read into the appropriate section of the Mysql-Manual, which is very detailed on how to perform a regular expression search.

answered Oct 25, 2012 at 18:41

Lars

5,8194 gold badges29 silver badges57 bronze badges

Comments

yegle · Accepted Answer · 2012-10-25 18:42:00Z

0

You can refer to mysql's regular expression match function.

http://dev.mysql.com/doc/refman/5.0/en/regexp.html

answered Oct 25, 2012 at 18:42

yegle

5,8756 gold badges42 silver badges62 bronze badges

Comments

Cups · Accepted Answer · 2012-10-25 18:45:00Z

0

IF its an X you are splitting on then this would do:

$var = "1234X32X12";

$bits = explode("X", $var);

var_dump( $bits);

array
  0 => string '1234' (length=4)
  1 => string '32' (length=2)
  2 => string '12' (length=2)

But I get the feeling X could be any alphabetical character, is it?

answered Oct 25, 2012 at 18:45

Cups

6,9063 gold badges29 silver badges30 bronze badges

1 Comment

Merica Over a year ago

No X is the split. so the number 1234X32X12 is equivalent to survey_idXpage_idXquestion_id...thanks for your help

Collectives™ on Stack Overflow

Using reg ex in PHP to query MYSQL

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related