I made following changes in /includes/classes/search/class-asp-search-terms.php :
1. Changed default value of $wcl variable to empty string.
[code]$wcl = ”; // Wildcard Left[/code]
2. Added another where clause to retrieve values where the word is not the first in the title string.
[code]/*———————– Title query —————————*/
if ($kw_logic == ‘or’ || $kw_logic == ‘and’ || $is_exact ) {
$parts[] = "
(" . $pre_field . $wpdb->terms . ".name" . $suf_field . " LIKE $pre_like’$wcl" . $word . "$wcr’$suf_like
OR " . $pre_field . $wpdb->terms . ".name" . $suf_field . " LIKE $pre_like’$wcr " . $word . "$wcr’$suf_like
)";
[/code]
And its giving desire output, but its affecting the performance. Could you please review it.
One quick question, since all required Taxonomies are indexed in index table can’t we disable source2 & add logic returning taxonomy terms as results in results returned by index table query?