Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why does your search use a like statement for $searchstring%, surely %$searchstring% would produces a better result?

April 26, 2017produces search SURELY

0

10 Posted

Why does your search use a like statement for $searchstring%, surely %$searchstring% would produces a better result?

1 Answer

0

10 Posted

It is quite correct that %$searchstring% would produce a better result, however the search would be very slow because we can’t make use of the index on the title field.