<?php
$sql="SELECT * FROM (SELECT col1, col2 FROM t1, (SELECT col3, col4 FROM t2) t3) t4";
echo preg_replace("/^SELECT (.*?) FROM .*/i", "\\1", $sql);
?>
$sql="SELECT * FROM (SELECT col1, col2 FROM t1, (SELECT col3, col4 FROM t2) t3) t4";
echo preg_replace("/^SELECT (.*?) FROM .*/i", "\\1", $sql);
?>
print_r( $res );
少加了参数
preg_match( "#SELECT (.+) FROM#isU", $sql, $res );
print_r( $res );
{
print_r($res);
}
自已写有点丑陋。
\s*SELECT\s+(.*?)\s+FROM\s+(.*)不过新问题来了。
见http://community.csdn.net/Expert/topic/4039/4039280.xml?temp=.6315424