MySQL | How to use regular expressions to show columns?

Question

I wanted something like this:
SELECT *Name FROM person
I would want this to return all the columns whose name has Name such as FirstName, LastName, MiddleName columns.

Is this possible in mySQL?

I would just list them all if I were you, I don't predict they would be more than 12 columns — niceman, Jun 06 '18 at 22:32
very similar https://stackoverflow.com/questions/4797686/selecting-all-columns-that-start-with-xxx-using-a-wildcard — niceman, Jun 06 '18 at 22:33
If your application doesn't know what the database's schema is there are larger problems at hand. — Sammitch, Jun 07 '18 at 00:21
I am just getting into databases. And I viewed `*` as a wild card so I thought it would be great/useful if it was possible to use it like that. — Azimjon Ilkhomov, Jun 07 '18 at 00:57

score 0 · Answer 1 · answered Jun 07 '18 at 03:14

Following query can be used to list all fields having name keyword(LIKE operations) in the column name in entire DB exists in MYSQL Server:

SELECT 
table_schema "Database", table_name, column_name,ordinal_position "Field Position" 
FROM information_schema.columns WHERE column_name LIKE '%name%'

MySQL | How to use regular expressions to show columns?

1 Answers1