how to display a text in a SELECT ?

[krystoffff]

Hi

It's probably a stupid question, but I can't find how to do that in
the MySQL documentation ...

I want to do the following query, or something like that:

SELECT id, "string"+id as text FROM ...

and the result should be:

id text
1 string1
2 string2
3 string3
... . ... for each id returned by the query

It looks stupid but I can't figure which operator (I tried '+', '.',
'|', '&') I can use for this purpose

Thanks for your help
krystoffff

[Brandon]

Try This:

SELECT id, CONCAT('string',id) as text FROM......

"krystoffff" <pr******@silesky.com> wrote in message
news:85**************************@posting.google.c om...

Hi

It's probably a stupid question, but I can't find how to do that in
the MySQL documentation ...

I want to do the following query, or something like that:

SELECT id, "string"+id as text FROM ...

and the result should be:

id text
1 string1
2 string2
3 string3
... . ... for each id returned by the query

It looks stupid but I can't figure which operator (I tried '+', '.',
'|', '&') I can use for this purpose

Thanks for your help
krystoffff

[Brandon]

Try This:

SELECT id, CONCAT('string',id) as text FROM......

"krystoffff" <pr******@silesky.com> wrote in message
news:85**************************@posting.google.c om...

Hi

It's probably a stupid question, but I can't find how to do that in
the MySQL documentation ...

I want to do the following query, or something like that:

SELECT id, "string"+id as text FROM ...

and the result should be:

id text
1 string1
2 string2
3 string3
... . ... for each id returned by the query

It looks stupid but I can't figure which operator (I tried '+', '.',
'|', '&') I can use for this purpose

Thanks for your help
krystoffff

[Brandon]

Try This:

SELECT id, CONCAT('string',id) as text FROM......

"krystoffff" <pr******@silesky.com> wrote in message
news:85**************************@posting.google.c om...

Hi

It's probably a stupid question, but I can't find how to do that in
the MySQL documentation ...

I want to do the following query, or something like that:

SELECT id, "string"+id as text FROM ...

and the result should be:

id text
1 string1
2 string2
3 string3
... . ... for each id returned by the query

It looks stupid but I can't figure which operator (I tried '+', '.',
'|', '&') I can use for this purpose

Thanks for your help
krystoffff