Java Regex ORing

Question

I have my query pattern as "^(select (skip \\d+)? (first \\d+))". I would like to match queries of type

1."SELECT * FROM X"
2."SELECT SKIP a FIRST b * FROM X"
3."SELECT SKIP a * FROM X"
4."SELECT FIRST B * FROM X"

The above regex i tried works fine for 1,2,3 but not for 4. Any ideas to what i should change the regex, so that all 4 patterns can be queried.

vks · Accepted Answer · 2015-05-11 09:00:02Z

1

^select (?:skip \d+\s+)?(?:first \d+\s+)?\* from X$

You can use this.See demo.

answered May 11, 2015 at 9:00

vks

68.1k11 gold badges96 silver badges132 bronze badges

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

Comments

Wiktor Stribiżew · Accepted Answer · 2015-05-11 08:59:28Z

0

You can use the following regex to match all of these entries:

select\s*(?:skip\s*\d+)?\s*(?:first\s*\d+)?(?:\s*\*?\s*from\s+\d+)?

answered May 11, 2015 at 8:59

Wiktor Stribiżew

631k41 gold badges502 silver badges632 bronze badges