SELECT * FROM mytable WHERE ((title LIKE '%ひろし%')AND(title LIKE '%すみれ%')AND(NOT((title LIKE '%ともぞう%')OR(title LIKE '%こたけ%'))));