How to make a selection from a database with such a structure?

Question

MySQL

Tell me how to make a SQL query to take order_id = 4 and the value field of shipping_id was equal to 76? It is for shipping_id, because the number 76 can be in other value records

Answer 1

select * from t
where order_id = 4
and name = 'shipping_id'
and value = '76'