Search Posts

Author: user24529

How to isolate query to find particular fields?

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 […]