Hi,Could someone help write a regex parsing sql str for me:)

Thread view:

jimmy - 23 May 2008 03:50 GMT

the sql :　　select * from (select * from tbl) a where c1 = 1 order
by c2 desc, c3 asc

I want to parse the 'order by' clause to get the column-order pair,
the result would be looks like:

['c2','c3'] ['desc','asc']

Greatly appreciated!

Reply to this Message

Andrew Thompson - 23 May 2008 04:28 GMT

Please refrain from multi-posting.

As an aside. What do you have so far in
your regex? What have you tried?

If the answer to both is 'nothing', then
perhaps what you need is a consultant.

(X-post to c.l.j.p./h. w/ f-u to c.l.j.p. only.)

--
Andrew T.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...