How to sort by text field and occurrence of substring?

Question

SQL

How to sort by a text field exactly by the occurrence of a substring? description is a description and in the selection, first get the products with certain occurrences in this field.
SELECT * FROM goods ORDER BY description

Answer 1

SELECT * FROM goods 
  ORDER BY CASE WHEN [с определенными вхождениям] THEN 0 ELSE 1 END, description