parsing SQL statement

From: beast@xxxxxxxxxx (Beast)
Date: Fri, 30 May 2008 19:24:07 +0700

Anyone having suggestion parsing SQL statement?

It should able to parse:

BLA BALA BALA...

VALUES(
'abcd efg',,999, 'some \"STRING\" and \'STR2\' STR3',,,, 'abcd, def, fghi'
)

I'm using tr and then split by "," but it will fall when seeing comma
inside the single quote.

Thanks.

--budhi
.

Follow-Ups:
- Re: parsing SQL statement
  - From: Matthew Whipple

Prev by Date: Re: cgi ordering a table with sql
Next by Date: Re: How perl program execution happened ?
Previous by thread: How perl program execution happened ?
Next by thread: Re: parsing SQL statement
Index(es):
- Date
- Thread