fork download 
  1. import re
  2. query = "SELECT `asd`.`ssss` as `column1`, `ss`.`wwwwwww` from `table`"
  3. table_and_columns = re.findall('`[^`\s]+`\.`[^`\s]+`',query)
  4. print(table_and_columns)
Success #stdin #stdout 0.03s 9384KB
comments (?)
stdin 
Standard input is empty
stdout 
['`asd`.`ssss`', '`ss`.`wwwwwww`']
https://ideone.com/UhFXVA
language:
Python 3 (python  3.9.5)
created:
4 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!