MySQL - How to use a variable as column name

Question

I want to use a registry as a column name but the registry is variable and I don't know when it changes.

Example:

Config (field) = 'Medicine'
FieldContent (another field) = 'Remedy name'

A want to make this:

Medicine (use content of Config as column name) = 'Remedy Name' (as registry)

What have I tried?

SET @CONFIG = SELECT CONFIG;

SELECT FIELDCONTENT AS @CONFIG FROM TABLENAME;

MySql says that I can't use a variable as column name. There's other way?

actual Config Content Medicine RemedyName

Wanted Medicine
RemedyName

Thanks!

fthiella · Accepted Answer · 2013-11-16 14:30:27Z

9

My idea is to use a prepared statement:

SET @config := (SELECT CONFIG FROM yourtable WHERE id=1);
SET @sql := CONCAT('SELECT FIELDCONTENT AS `', @config, '` FROM TABLENAME');

PREPARE stmt FROM @sql;
EXECUTE stmt;

answered Nov 16, 2013 at 14:30

fthiella

49.2k15 gold badges96 silver badges108 bronze badges

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

Collectives™ on Stack Overflow

MySQL - How to use a variable as column name

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related