(SQL) Sum int values from more fields in the same row
I need to create a query that sum more values (0 or 1) from more fields in the same row.
Example:
id: 1
title: Lorem Ipsum 1
eng: 1
deu: 1
por: 1
tur: 1
id: 2
title: Lorem Ipsum 2
eng: 0
deu: 1
por: 0
tur: 1
I need to sum "eng", "deu", "por", "tur", creating a new dynamic field in the recordset with the value "4" for id 1, "2" for id 2, etc ...
Expected result of the query (create with WebAssist MySQLi Recordset):
id: 1
title: Lorem Ipsum 1
eng: 1
deu: 1
por: 1
tur: 1
sum: 4
id: 2
title: Lorem Ipsum 2
eng: 0
deu: 1
por: 0
tur: 1
sum: 2
Is it possible?