double proximity

Post Reply
kzinda
Posts: 62
Joined: Fri Nov 30, 2001 6:18 am

double proximity

Post by kzinda »

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
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

double proximity

Post by mark »

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)!=''
Post Reply