SQL Select and concatenating strings

[mikeym]

Hi,

Sorry this isn't really the place for this but I was wondering if anyone could tell me quickly how to concatenate strings together in an SQL statement like:



SELECT `page` + '#' + `section` AS 'url'
FROM `bbcode`

Which currently returns '0' for each field.

[Keith Hedger]

I think this is what u need
mysql> SELECT CONCAT('My', 'S', 'QL');
-> 'MySQL'
mysql> SELECT CONCAT('My', NULL, 'QL');
-> NULL
mysql> SELECT CONCAT(14.3);
-> '14.3'

u might want to install the docs for my sql via synaptic (mysql-doc-5.0)

[CptPicard]

The standard string concatenation operator in SQL is ||. Like 'Add this' || ' to this'.

[henchman]

There's an useful overview of mysql's string manipulation functions (including CONCAT and CONCAT_WS) here:

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html

[CptPicard]

The OP isn't saying anything about MySQL... there are other SQL databases you know :)

[henchman]

Sorry... sql seem to be automatically mysql for me...:(

[Keith Hedger]

yeah same here but isn't the basic syntax on sql standard?

[CptPicard]

yeah same here but isn't the basic syntax on sql standard?

Yes. That's why he should be using the standard '||' (IIRC) instead of nonstandard mysql functions :)