SQL sentences

Question

I'am trying to make SQL sentences like:
The company + company + budget is + budget + .

But i can't seem to find out how 😕

Answer 1

So I wrote and tested like this:

SELECT "my name is" , name FROM table1 WHERE id=1

but return something like this:

| my name is | pedro |

two columns

If you want to concat, use a function SELECT CONCAT ( str1, str2 )

arguments str1, str2 are strings

Answer 2

Its for school and the assignment says i cant use php.

Answer 3

Thanks Pedro it was concat i was looking for 😀

Answer 4

How is your database and table ?

I guess that you need a select multiple tables.

Answer 5

And yes i normally use php too for this 😀

Answer 6

Pedro H.J Hi pedro. I just want to make a sentence with values from the database inside the sentence. Like:
'Hi my name is: ' + users.name

Without using php 😀

Answer 7

I make this with PHP.

Exemplo

echo "my name is";
echo $var ;

Where var is a variable SELECT result from MYSQL database.

Answer 8

whaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaat