I have a table in V8.1.2 (Windows) which contains about 17,000
constant rows. One column contains a string of about 20 English
words. I need to find all rows which contain three words specified by
their first letters.
For example, if I am looking for rows containing Jon (or Jonathan) and
Will (or William) and Terry (or Terri or Terrance), the SQL would be:
SELECT col1 FROM MYTAB WHERE col2 LIKE '%Jon%' AND col2 LIKE '%Will%'
AND col3 LIKE '%Terr%'
The first % because the word could occur anywhere in the field.
It works now by brute force. Would it work better by using Net Search
Extender to index col2?
Stan
constant rows. One column contains a string of about 20 English
words. I need to find all rows which contain three words specified by
their first letters.
For example, if I am looking for rows containing Jon (or Jonathan) and
Will (or William) and Terry (or Terri or Terrance), the SQL would be:
SELECT col1 FROM MYTAB WHERE col2 LIKE '%Jon%' AND col2 LIKE '%Will%'
AND col3 LIKE '%Terr%'
The first % because the word could occur anywhere in the field.
It works now by brute force. Would it work better by using Net Search
Extender to index col2?
Stan