Is there a way in sql to write a query that returns all results other than ones containing "This"
So in my mind it would look something like this but I know it doesn't work
$sql = 'SELECT * FROM tablename EXCLUDING WHERE col1 = This'
$sql = 'SELECT * FROM tablename WHERE col1 NOT LIKE "%This%"'
MySQL NOT LIKE is used to exclude those rows which are matching the criterion followed by LIKE operator.