devenh
13th of February 2007 (Tue), 11:16
EE's search features are great, but it is limited to string matching. For instance, search for 'clouds water' and all matching records will contain that exact string, but it will miss records that contain 'clouds over water.' So EE is doing something like:
%SearchString% IN FieldName
What I would suggest is a simplified implementation of full text search where the search string was parsed into individual words and the search was performed as follows:
(%Word1% IN FieldName) and (%Word2% IN FieldName) and (...etc...)
Performing the search in this manner would -- I believe -- will produce results more in line with what the user have come to expect.
Deven
%SearchString% IN FieldName
What I would suggest is a simplified implementation of full text search where the search string was parsed into individual words and the search was performed as follows:
(%Word1% IN FieldName) and (%Word2% IN FieldName) and (...etc...)
Performing the search in this manner would -- I believe -- will produce results more in line with what the user have come to expect.
Deven