MySQL query parser.

[EKINdesigns]

Hey, can anyone supply me with a mysql quer parser.

Something that returs all the variables of a query string.

Example:

SELECT `id`,`name` FROM `table_name` WHERE `id`='2'

Would return:
[0] => 'SELECT'
[1] => [0] => 'id' [1] => 'name'
[2] => 'FROM'
[3] => 'table_name'
[4] => 'WHERE'
[5] => [0] => 'id' [1] => '=' [2] => '2'

And possibly do more advanced parsing than that.

If anyone can help i would appreciate it a lot!