Trying to return data from fields containing an underscore char

[Philippe Lévi]

Hello experts,

Being an (almost) newbie in php, I am facing a probably simple issue which I just can't solve given my limited knowledge there.

I inherited a Joomla website database where a series of fields in a table are like 'name_fr-FR' or 'name_en-GB' etc...
These fields obviously contain various language variants for the same product.

- When I try to load data with, say, "select name_fr-FR from table xxxx" I keep
getting a 1054 error.
- If I do a "select * " I don't get any complaint but when I do
foreach ($products as $pr)
echo $pr->name_fr-FR;

it returns absolutely nothing meaning that either it did not fetch the data or it doesn't want to output it.

I read around that I should kind of escape the _ in the field name but can't figure it out.

Can anyone help me out there?

Thx and happy holidays from Paris, France.

Philippe