SQL query - how to find rows that do not contain text?

Question

SQL

Which query will display rows that do not contain certain text in a column?
For example:
- there is a table "post"
- there is a column "xfields"
- there is a phrase "boots" among a lot of other text in the xfields column It is
necessary to display all rows that do not contain the phrase boots in the xfields column.

Answer 1

SELECT * FROM post WHERE xfields NOT LIKE '%boots%'

Please note that LIKE %% does not use indexes and such a query will always result in a fullscan of the table.