Search Posts

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 besides ‘Data’ fields, how do I find academics(acnum) that are interested ONLY in ‘Data’ fields(descrip)?

Thank you.

Source: Stackoverflow

Leave a Reply

Your email address will not be published. Required fields are marked *