How would I specify as search string where I want to find two words within proximity of each other, but that also must be within a much larger delimited section e.g. (word1 word2 w/20) w/\sectionstart w/\sectionend
Something like this should do it: select * from test where Body like 'word1 word2' and mminfo('word1 word2 w/20',mminfo('word1 word2 w/sectionstart w/sectionend',Body),0)!=''