Add ability to use index searching from beginning of a word

  • Thread starter Thread starter bheavican
  • Start date Start date
Status
Not open for further replies.
B

bheavican

Guest
Currently when doing a CONTAINS search, you can add an asterisk to the end of a word to find words that begin with some letters (i.e. searching for basket* would return records with the word basketball). In order to find all records that ended with "ball" though you have to use the MATCHES operator and then the entire table is scanned. Can you add an ENDS WITH operator or enhance the CONTAINS search to match the ending of a word AND use an index so results can be found in a performance enhanced manner (i.e. searching for *ball would return basketball records but also uses an index)?

Continue reading...
 
Status
Not open for further replies.
Back
Top