Need help adding a prefix to product id with SQL Query.

[turdi]

Hello,

 

First of all, sorry about the basic question, but I'm pretty bad at forming the SQL queries...

 

I have a simple query to get the id and qty, but in this case I need to add a prefix to all the ID's.

SELECT p.id_product, p.quantity
FROM ps_product p
GROUP BY p.id_product

I've tryed

CONCAT('v4',p.id_product) as p.id_product 

but with no luck.

 

Trying to learn and understand how it works.

Thanks you!!!

[JeredBolton]

It doesn't work because you're trying to output the concatenated string AS an existing table column. Call it something different and it will work fine:

SELECT p.id_product, p.quantity, CONCAT('v4',p.id_product) AS new_id_product
FROM ps_product p
GROUP BY p.id_product

Edited February 16, 2017 by JeredBolton (see edit history)

[turdi]

Thank you !! 

One more question, do you know in witch table I can find the Final price value? 

I can't find it in the database... I have found base price in ps_product table, but can't find the final price... 

 

Thank you!!

[bellini13]

define 'final price' ?

[musicmaster]

If you mean price+VAT with final price you won't find it. It is a calculated value. Prices after discounts too are calculated values that aren't stored as such in the database.