When I concat($name, $surname), is there a way of putting a space in between the $name $surname using my sql not php so when i get the result it formats a little cleaner?
Add a comment
|
8 Answers
You can concatenate string literals along with your fields, so you can add a space character in a string between the fields you're concatenating.
Use this:
CONCAT(name, " ", surname)
This functionality is documented quite clearly on the MySQL manual page for the CONCAT() function.
There is also the CONCAT_WS function which allows you to specify a separator to be used between each of the other fields passed to the function. If you're concatenating more than two fields in the same way, this function might be considered cleaner than repeating the separator between each field.
For example, if you wanted to add a middle name field, you could use this function to specify the separator only once:
CONCAT_WS(" ", first_name, middle_name, surname)
Comments
Just add a space in there.
SELECT CONCAT(name,' ',surname) AS full_name FROM table;
EDIT oops, bad spelling there... ;p
2 Comments
Brad Christie
@OMGPonies: I'm going with luck on this one. ;-)
Joe Stefanelli
+1. Just to be safe, I'd expand this to:
CONCAT(COALESCE(name,''),' ',COALESCE(surname,''))Use this, no version dependencies
concat(name,Char(32),venue)
Comments
Use CONCAT(name, ' ', surname).
Comments
Hey i had the same problem and this is what i used and it really worked out great
CONCAT(column1," ",column2) the issue is you add physical space in between the double courts("") using the space bar on your keyboard and then thats it
1 Comment
patricksweeney
What's different about this compared to the answers from a few years ago?
The above all options are not working ..
My query is
SELECT CONCAT(FIRSTNAME, ' ' , LASTNAME) AS FULLNAME FROM USERS;
getting the below error:
ORA-00909: invalid number of arguments 00909 00000- "invalid number of arguments" *Cause: *Action: Error at line 26 column :9
1 Comment
Tyson Freeze
Try
CONCAT(CONCAT(FIRSTNAME, ' '), LASTNAME), it can probably only handle two arguments at a time.Use this methoid to add separator
EXAMPLE 01
CONCAT_WS(' ', first_string, second_string, n_string, ..., last_string)
Output:
"first_string second_string n_string ... last_string"
EXAMPLE 02
CONCAT_WS('-', first_string, second_string, n_string, ..., last_string)
Output:
"first_string-second_string-n_string-...-last_string"
