MySQL: Query that finds all states that does not contain a specific value
<p>I have a table with information regarding different places (landmarks/cities etc). </p>

<p>Each row represents one landmark, and amongst the columns, we have state and we have type.</p>

<p>So I want to find all states that does not contain a specific type. Let’s say that does not contain a river.</p>

<p>Thanks,</p>