append 2 or more fields in a select statement

[justride]

Hi,

How can I append 2 or more fields in a select statement.

ex:

SELECT *, `RESTPHONE1`+`RESTPHONE2`+`RESTPHONE3` AS NUMBER FROM RESTAURANTS

I want a string of 9 digits. ###.###.####

Thanks

 

[Bastien]

select *, concat(RESTPHONE1,"-",RESTPHONE2,"_",RESTPHONE3)...


select *, concat_ws("-",RESTPHONE1,RESTPHONE2,,RESTPHONE3)...


the _WS stands for with separator so you can define the separator first and then its just plugs them in.




Bastien

Cat, the other other white meat

 

[justride]

Thanks dude, that was what i was looking for!

 

[justride]

One more question,
will something like this work...

select *, FROM RESTAURANTS WHERE concat(RESTPHONE1,RESTPHONE2,RESTPHONE3) = '$number'

 

[Bastien]

try it

Bastien

Cat, the other other white meat