Dynamic conversion of string into column name. MySQL

by

You may want to see the answer to this question, which I believe is what you’re trying to accomplish. In short, the answer suggests using prepared statements in order to simulate an eval()-esque functionality. In your case, this may work (you can see the SQLFiddle here:

SELECT transaction_type FROM orders WHERE id=1 into @colname;
SET @table="items";
SET @query = CONCAT('SELECT ',@colname,' FROM ', @table);

PREPARE stmt FROM @query;
EXECUTE stmt;

I won’t claim to be any sort of expert on the underlying mechanics at work, but per the comments it seems to achieve the goal. Again, this was adopted from another answer, so if it works makes sure to +1 that one 🙂

More Related Contents:

  1. Out of memory Microsoft VBScript runtime error 800a0007
  2. Left Outer Join doesn’t return all rows from my left table?
  3. Are table names in MySQL case sensitive?
  4. MySQL: is a SELECT statement case sensitive?
  5. 1114 (HY000): The table is full
  6. Get table names using SELECT statement in MySQL
  7. UPDATE multiple tables in MySQL using LEFT JOIN
  8. Can a foreign key reference a non-unique index?
  9. How to raise an error within a MySQL function
  10. What is maximum query size for mysql?
  11. Storing Data in MySQL as JSON
  12. Finding all parents in mysql table with single query (Recursive Query)
  13. How do I retrieve my MySQL username and password?
  14. How to execute a MySQL command from a shell script?
  15. Select most common value from a field in MySQL
  16. MySQL update a joined table
  17. Returning the ‘last’ row of each ‘group by’ in MySQL
  18. How does a MYSQL Self-Join Work?
  19. How to change the default port of mysql from 3306 to 3360
  20. Is it possible to reference one column as multiple foreign keys?
  21. No Entity Framework provider found for ‘MySql.Data.MySqlClient’ ADO.NET provider
  22. How to Import Multiple csv files into a MySQL Database
  23. MySQL error #2014 – Commands out of sync; you can’t run this command now
  24. Row to column transformation in MySQL
  25. Data truncated for column?
  26. mysql select id and name from other table and join query
  27. The web application [] appears to have started a thread named [Abandoned connection cleanup thread] com.mysql.jdbc.AbandonedConnectionCleanupThread
  28. Execute INSERT if table is empty?
  29. Mysql How do you create a clustered index?
  30. MySQL data directory location

Leave a Comment