extend nestedsets with fulltext query
| From: | roman stachura | Date: | Sun, 30 Jan 2005 17:10:26 +0000 |
| Subject: | extend nestedsets with fulltext query | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-17275@lists.php.net to get a copy of this message | ||
Hi all
Is there a way to do a fulltext search with db nestedsets class?
Something like :
$addSQL = array(
'WHERE MATCH' => 'name, content',
'AGAINST' => 'willkommen'
);
$search = $NSsmarty->getAllNodes(true, true, $addSQL);
Without the nestedsets class its working:
$search_query = "SELECT name,
id,
content,
link
FROM nestedset
WHERE MATCH content,
name
AGAINST ('willkommen')
";
--> http://dev.mysql.com/doc/mysql/en/fulltext-search.htmlRegards roman