求高手帮忙写一个php分解sql语句匹配正则

[vgy12304]

需要分解的sql语句：

select * from tjw_person where personname like '%南京%' and uid=16782132 and uid>10000 and uid<1000000 and uid in(16791444,16782132,16807195) and (uid=16782132 and sex=0) or (uid=1304049 and sex=1)

期望的结果：

array=(
'0'=>personname like '%南京%',
'1'=>and uid=16782132,
'2'=>and uid>10000,
'3'=>and uid<1000000,
'4'=>and uid in(16791444,16782132,16807195),
'5'=>and (uid=16782132 and sex=0)，
'6'=>or (uid=1304049 and sex=1)
)

[vgy12304]

附上取where所有条件的正则
if(stripos($sql,'order')!==false){
preg_match("/where\s+(.*)\s*order/",$sql,$matchs);
}elseif(stripos($sql,'group')!==false){
preg_match("/where\s+(.*)\s*group/",$sql,$matchs);
}elseif(stripos($sql,'limit')!==false){
preg_match("/where\s+(.*)\s*limit/",$sql,$matchs);
}else{
preg_match("/where\s+(.*)\s*/",$sql,$matchs);
}
$where=trim($matchs[1]);

[xuzuning]

只用简单的正则估计是做不到的
你可以这样写

$s =<<< TXT
select * from tjw_person where personname like '%南京%' and uid=16782132 and uid>10000 and uid<1000000 and uid in(16791444,16782132,16807195) and (uid=16782132 and sex=0) or (uid=1304049 and sex=1)
TXT;

$t = preg_split('/(\bwhere\b|\bgroup\b|\border\b|\blimit\b)/i', $s, -1, PREG_SPLIT_NO_EMPTY | PREG_SPLIT_DELIM_CAPTURE);

$t = preg_split('/(\band\b|\bor\b)/i', $t[2], -1, PREG_SPLIT_NO_EMPTY | PREG_SPLIT_DELIM_CAPTURE);
for($i=0; $i<count($t); $i++) {
  $v = $t[$i];
  if(in_array($v, array('and', 'or'))) {
    $v .= $t[++$i];
    if(strstr($v, '(')) while(!strstr($v, ')')) $v .= $t[++$i];
  }
  $r[] = $v;
}
print_r($r);

Array
(
    [0] =>  personname like '%南京%' 
    [1] => and uid=16782132 
    [2] => and uid>10000 
    [3] => and uid<1000000 
    [4] => and uid in(16791444,16782132,16807195) 
    [5] => and (uid=16782132 and sex=0) 
    [6] => or (uid=1304049 and sex=1)
)

[vgy12304]

楼上的正解，非常感谢