So really what you want is introtext that matches a certain word to come before the others and state=1 in either case?
The CASE expression puts all the rows where you match the word you are looking for in introtext before the non matching rows and then orders them by created descending in both cases.
CASE WHEN introtext LIKE '%something%' THEN 0 ELSE 1 END,
By the way it may have only been your example but if you are looking for an exact match then you use = if you are using LIKE then you are looking for a word in introtext that either has text before or after it, thus the wild cards i've added.
The other thing i've done is removed quotes from around numeric data.