Im making a regex expression using C# to extract the where clause of a sql expression. The whre clause can have multiple columns with different operators. Though NO grouping is allowed in the sql e.g. 

```
col1 = 5 and (col3 = 6 or col4 < 5)

```

Only a simple format is allowed in the sql:

```
col1 = 5 and col1 < 6 or col3 <> ?

```

I have been trying to do it with the following , but the "and" and "or" keywords seem to be caught, and it doesnt capture all:

```
.*?(?<columnname>.+?)(?<operator>=|<|>|<>)(?<value>.+?)\s

```