I am trying to get data from my database. I have no problems with this, the SELECT statement works fine, but I want to select the record with a symbor or text before the result.
When I run the code:
WHERE id = "1"
SELECT "€ " + price as 'price'
Since you specified what is your RDBMs your answer is:
SELECT CONCAT('€ ', price) as price FROM products WHERE id=1
Don't use double quotes to use strings, double quotes on SQL is to name things like columns as alias and only use it when you want a field named with characters that the database wouldn't allow it like
"Column name with spaces"
ID is probably a number, so no need to use quotes since it will imply in implicit conversion which will make your query slower.