Reply To: Short Term Search SQL Query

@ Brittany

This really is not a bug. When FULLTEXT queries are performed they are setup to do a “term starts with” query. FULLTEXT actually does not support “term contains” type of queries. So, when the LIKE query is created, I chose to use the “term start with” syntax in order to match the search performed by FULLTEXT queries.

If you want a LIKE query to perform a “term contains” searches, I can look into adding a filter that you can hook into to change the query. I do not think I will change the default behaviour. Let me know if you would like a filter and I’ll take a look on how it might be best to implement it.