using C# regex. question is how to use "="

Question

I`m parsing SQL query with C# Regex.

I need also to make my pattern to understand "=", for example:

string pattern = @"...something...(where)\s\w*\s*(order by)*...something else...";

the following query should match my pattern:

select fieldslist from mytable where fieldvalue=someint order by specialfield

how can I change the interval of char (I mean "\w*") to make pattern understand my SELECT correctly?

Vinko Vrsalovic · Accepted Answer · 2008-10-28 18:48:37Z

3

Use a character class instead of \w

    \w = [A-Za-z0-9_]

(that is, from A to Z, from a to z from 0 to 9 plus _)

Just add any additional character you want:

    [A-Za-z0-9_=] 

    string pattern = @"...something...(where)\s[A-Za-z0-9_=]*\s*...";

answered Oct 28, 2008 at 18:48

Vinko Vrsalovic

342k55 gold badges341 silver badges374 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1