Retrieving single values from MySQL

 

I have spent hours searching for code samples showing how to retrieve a single value from MySQL. All samples are returning

complete rows. They work. But I want to do qualified retrivals like "Select xxx from table1 where yyy equals zzz". Tried a few variations

but could not get it working

Reason: