如何不区分大小写，不重复的select数据，并去除其中不想要的项

SELECT DISTINCT
*
FROM
sdb_post
WHERE
"upper"(subject)LIKE "upper"('%rasterdataset%')
AND subject NOT LIKE '回复%'
OR "upper"(message)LIKE "upper"('%rasterdataset%')