Php 抓取 sql order 的正規式

這樣就可以了~ 記起來懶得在寫一次!

$sql = 'SELECT * FROM `epc_user` GROUP BY userID ORDER BY `userNo` ASC,xxx DESC limit 0,30';
preg_match('/order\s+by\s+(.*?)\s?(limit|$)/i', $sql, $matches);
print_r($matches);

Array (
[0] => ORDER BY `userNo` ASC,xxx DESC limit
[1] => `userNo` ASC,xxx DESC
[2] => limit )