MySQL request to get HT price from TTC price

[kolorslab]

Hi,

I need to got - with only a 20% TVA - get for all my products a MySQL request to get HT prices form the TTC prices cause all prices in DB are the same for the HT and the TTC price value.

I work on PS1.7.6.3 and i need to convert the TTC price to HT price in the HT products price value.

I have search but i don't know how to get a MySQL request to get HT values in the DB from the TTC prices.

I have to change the value from the TTC price with 20% TVA ton get the HT price value for al products.

Someone has an idea and can give me some ideas to update the value of HT prices from the TTC price to get -20% in the HT value.

Thanks for your help guys

Best

kolorslab