sql - query, where field contains 2 t's -

is there way perform clause match 2 t's independent off located.

such

matthew -- work

thanatos -- work

thanatos t -- not work

tom -- not work

i've been googling cant find specific this

any apreciated

you try

select * table field '%t%t%' , field not '%t%t%t%' 

i'm curious faster, or goat co's answer.