how to – How to isolate query to find particular fields?
Here is the database I’m using: https://drive.google.com/file/d/1ArJekOQpal0JFIr1h3NXYcFVngnCNUxg/view?usp=sharing
I’m trying to create a query to output the academics (acnum) who are ONLY
interested in “Data” (descrip) fields.
I tried this:
select acnum from interest where upper(descrip) like '%DATA%';
It partly works, it finds the academics(acnum) that are interested in fields(descrip) with ‘Data’ in their names, but it also lists the academics(acnum) that have other interests besides ‘Data’ fields, how do I find academics(acnum) that are interested ONLY in ‘Data’ fields(descrip)?