Regular expression in MySQL / SQL?

Question

i have for example:

tableAaa:
id | titleSSS
1  | sfdf
2  | sdfs

tableBbb:
id | titleUUU
1  | sfdf
2  | sdfs

tableCcc:
id | titleIII
1  | sfdf
2  | sdfs

etc, for example * 10.

Is possible make something like:

SELECT title* FROM table*

If yes, how?

EDIT: i dont want use UNION and do select from each table... These table is ~100. I would like make regular expression.

dorsh · Accepted Answer · 2012-02-03 13:10:08Z

1

You can do it, but you'll have to list all column and table names manually:

SELECT titleSSS FROM tableAaa
UNION ALL
SELECT titleUUU FROM tableBbb
UNION ALL
SELECT titleIII FROM tableCcc

Note that you must use UNION ALL instead of UNION or otherwise you won't get duplicate rows in the output. Read more here: http://dev.mysql.com/doc/refman/5.0/en/union.html

answered Feb 3, 2012 at 13:10

dorsh

24.9k2 gold badges30 silver badges30 bronze badges

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

6 Comments

Paul Attuck Over a year ago

i dont want make select from each table... these table is ~100

dorsh Over a year ago

@PaulAttuck then generate this SQL statement in PHP

Paul Attuck Over a year ago

and how can i get name table beginning of "title" from MySQL to PHP?

dorsh Over a year ago

@PaulAttuck show tables where tables_in_<dbname> like 'table%';

Paul Attuck Over a year ago

thanks +1, and how to show all name columns of these table? :)

|

Community · Accepted Answer · 2017-05-23 12:03:32Z

1

The thing require by you is might not be possible you can do as below

SELECT title1 FROM table1
union
SELECT title2 FROM table2
union
SELECT title3 FROM table3

OR

You can make use of DynamicSQL to resolve your issue easily. ans for you : How To have Dynamic SQL in MySQL Stored Procedure

edited May 23, 2017 at 12:03

CommunityBot

11 silver badge

answered Feb 3, 2012 at 13:07

Pranay Rana

177k37 gold badges244 silver badges267 bronze badges

3 Comments

Paul Attuck Over a year ago

i know, but i would like make regular expression for this. I have these table 100

Paul Attuck Over a year ago

how to use DynamicSQL for this? :)

Pranay Rana Over a year ago

@Paul Attuck - here is link for you stackoverflow.com/questions/190776/…

Collectives™ on Stack Overflow

Regular expression in MySQL / SQL?

2 Answers 2

6 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related