fork download 
  1. import re
  2. p = '(?i)SELECT (?P<columns>.*) FROM (?P<source>.*?)(?: WHERE (?P<where_clause>.*))?;$'
  3. strs = ['select * from t1;', 'select * from t1 where c1 == 0;']
  4. for s in strs:
  5. 	m = re.match(p, s)
  6. 	if m:
  7. 		print(m.group("columns"))
  8. 		print(m.group("source"))
  9. 		print(m.group("where_clause"))
Success #stdin #stdout 0.02s 28384KB
comments (?)
stdin 
Standard input is empty
stdout 
*
t1
None
*
t1
c1 == 0
https://ideone.com/7PzQeN
language:
Python 3 (python  3.12)
created:
8 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!