As aziz-shaikh has pointed out, there is no way to suppress an individual column from the * directive, however you might be able to use the following hack.
You can use the CONCAT function like this: SELECT CONCAT(`SUBJECT`, ' ', ` YEAR`) FROM `table`. Update: To get that result you can try this: SET @rn:= 0.
MySQL CONCAT() function is used to add two or more strings. on columns; MySQL CONCAT using WHERE clause; MySQL CONCAT returns.
MySQL Functions The CONCAT() function adds two or more expressions together. Note: Also look at the Add three columns into one "Address" column.
In MysQL you concatenate multiple columns, by using CONCAT and CONCAT_WS function. This saves you some of the time on the.
Summary: in this tutorial, you will learn various ways to concatenate two or more strings together by using the MySQL CONCAT and CONCAT_WS functions.
MySQL Concat Multiple Columns into One. There are two possibilities while writing query to combine multiple columns. Let's see in detail.