Concat a string to SELECT MySql

Question

The following query works fine with MySQL   SELECT concat title      FROM  socials  WHERE 1   It Concat   to the selected title field   However  when I try to do the following   SELECT concat        FROM  socials  WHERE 1   It returns the follwoing Error     1064 - You have an error in your SQL syntax  check the manual that corresponds to your MySQL server version for the right syntax to use near         FROM  socials  WHERE 1 LIMIT 0  30  at line 1   So is there any way to make such sql query to work with MySql

User · Answer

If you want to concatenate the fields using / as a separator, you can use concat_ws:

select concat_ws('/', col1, col2, col3) from mytable

You cannot escape listing the columns in the query though. The *-syntax works only in "select * from". You can list the columns and construct the query dynamically though.

User · Answer

You cannot concatenate multiple fields with a string  You need to select a field instand of all

User · Answer

You simply can t do that in SQL  You have to explicitly list the fields and concat each one   SELECT CONCAT field1        CONCAT field2            FROM  socials  WHERE 1   If you are using an app  you can use SQL to read the column names  and then use your app to construct a query like above  See this stackoverflow question to find the column names  Get table column names in mysql

User · Answer

You cannot do this on multiple fields  You can also look for this

[mysql] Concat a string to SELECT * MySql

Examples related to mysql

Examples related to sql

Examples related to string

Examples related to concat