command with optional parameters

[The Little Guy]

I have the following code:

"~^create table `?(.*)`?(\(?(.*)\)?)$~"

 

I would like to have the strings that match up to that look like this (where 'cat' can be anything, same with 'c1' and 'c2'):

 

create table `cat`

create table cat

create table `cat` (`c1`, `c2`)

create table cat (`c1`, `c2`)

 

When the array is returned, from my preg_match I would like to have my array look like this (key number don't matter but must be the same every time):

 

Array(
[0] => 'cat'
[1] => '(`c1`, `c2`)'
)

 

OR...

 

Array(
[0] => 'cat'
[1] => Array(
	[0] => 'c1'
	[1] => 'c2'
)
)

 

currently I can not get it to return properly, and my above regex returned this:

 

Array
(
    [0] => create table `fire` (c1,c2)
    [1] =>
    [2] => fire` (c1,c2)
    [3] => fire` (c1,c2)
)

 

How can I get that?