MATCH(column) AGAINST(searchitem)

I have developed a knowledge base website.
For the moment I search for certain strings with contains.
I want to add a fulltext index and then search with MATCH(column) AGAINST(searchitem)

At this moment this is not a option in DataAssits 2.08.
What is the best solution to handcode in the generated RESULTspage.

John den Os
Leiden
Netherlands

when you create the full text index, make sure to name it the same as the column you are indexing


my example assumes the table is named "tblName" and the index is named "column"

it also assumes the search form uses the POST method and the search term element is named "searchitem"

create the following recordset in advanced mode:
SELECT *
FROM tbleName
WHERE MATCH(column) AGAINST(paramSearchItem IN BOOLEAN MODE)

in the variables section, create a new variable as:
name: paramSearchItem
Type: Text
Default Value: -1
Runtime Value: $_POST['searchitem']


in the past, I have had mixed results doing full text searches this way.