Get KeyValuePair into Array from string using regex

Question

I am working on a project and I can't figure out how to go about doing it. I'm trying to do with Regex but fairly new to it.

I have a string such as WHERE MyColumn='1's'' AND MyColumn='Test's''"

I have the following regex in PHP

$found = array();
preg_match("/\s=\s'.*'|\s.*='.*'\s/", $whereQuery, $found);

In my array I have the following

Array
(
    [0] =>  MyColumn='1's'' 
)

So it's almost there, except I am expecting the following:

Array
(
    [0] =>  MyColumn='1's'' 
    [1] =>  MyColumn='Test's'
)

preg_match only return first match. If want multiple matches, use preg_match_all. — Capital C
– Capital C, Commented Aug 25, 2016 at 19:03
Use an SQL parser. Stop to try to parse the SQL language with regex, it's a waste of time. — Casimir et Hippolyte
– Casimir et Hippolyte, Commented Aug 25, 2016 at 21:09

anubhava · Accepted Answer · 2016-08-25 19:03:21Z

1

You should use preg_match_all with this simplified regex:

preg_match_all('/\w+\h*=\h*\S+/', $whereQuery, $found);

answered Aug 25, 2016 at 19:03

anubhava

790k67 gold badges603 silver badges671 bronze badges

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

1 Comment

Wow that is much simpler. Works great