How to access the specific value in table according to the input parameters?

I am working with SQL database and convert it to matlab table using

results = fetch(conn,sqlquery);
LCA_Database = cell2table(results);

LCA_Database looks like this:

My question is how can I access the data stored in for example 11 column pentr according to the input parameters: Name == 'Construction Steel' and lca_phase == 'D' ?

I cannot change the rows and columns as all database is structured like that. AS well I cannot assign the rownames to the name of material as it remains the same for 5 rows and matlab do not allow me to do that.

Can I create new table out of this table with automatic assignment of rownames that will contain name of the material + lca_phase?

Answer 1

[madhan ravi]

LCA_Database(contains(LCA_Database.Name,'Construction Steel')&contains(LCA_Database.lca_phase,'D'),:)

[Konstantin Tkachuk]

My greatest thanks to you!