==== Wikka Mod 029 ====
Type: Feature Addition
----
===Credit:===
**[[PolVazo | pmyatt]]** -- for the original idea and function code.
----

Use MySQL "UNION" to search for text in TAG as well as the full text search that often returns no results.

This will search for **partial** matches in page titles (tags). This is of great benefit because the regular search would not find a search for the word "camel" even if you had a page named "CamelCase". This modified search will now find that page.


Here is the function I added in **wakka.php**:
%%(code)
function FullTextSearchAndLikeTags($phrase) {
return $this->LoadAll(" (select * from ".$this->config["table_prefix"]
."pages where latest = 'Y' and tag like('%".mysql_escape_string($phrase)
."%')) UNION (select * from ".$this->config["table_prefix"]
."pages where latest = 'Y' and match(tag, body) against('".mysql_escape_string($phrase)."'))");
}
%%

Then I modified **actions/textsearch.php** and **actions/textsearchexpanded.php** to use the new function.
----
**Alternative way to do it**
This is the way I did it with MySQL v4 as the above only works with MySQL v3. In wikka.php change the function FullTextSearch from:
%%
{
$data = $this->LoadAll("select * from "
.$this->config["table_prefix"]
."pages where latest = 'Y' and match(tag, body) against('".mysql_real_escape_string($phrase)
."' IN BOOLEAN MODE) order by time DESC");
}
%%
To:
%%
{
$data = $this->LoadAll(" select * from "
.$this->config["table_prefix"]
."pages where latest = 'Y' and tag like('%".mysql_escape_string($phrase)."%') UNION select * from "
.$this->config["table_prefix"]
."pages where latest = 'Y' and match(tag, body) against('".mysql_real_escape_string($phrase)
."' IN BOOLEAN MODE) order by time DESC");
}
%%
--pmyatt

To to this in v1.3.1
In /libs/Wakka.class.php
Replace:
%%(php)
$sql = 'select * from '.$this->config['table_prefix'].'pages';
$sql .= ' where latest = '. "'Y'" .' and match(tag, body'.$id.')';
$sql .= ' against('. "'$search_phrase'" .' IN BOOLEAN MODE)';
$sql .= ' order by time DESC';
%%
with
%%(php)
$sql = 'select * from '.$this->config['table_prefix'].'pages';
$sql .= ' where latest = '. "'Y'" . " and tag like('%" . mysql_escape_string($search_phrase) . "%') UNION select * from ";
$sql .= $this->config['table_prefix'] . 'pages where latest = '. "'Y'" .' and match(tag, body'.$id.')';
$sql .= ' against('. "'$search_phrase'" .' IN BOOLEAN MODE)';
$sql .= ' order by time DESC';
%%


''Great, thanks. This will be added to version 1.1.5.4.'' -- JsnX