full text search with active records?

[eluser]Seppo[/eluser]
That was my first thought... However I think that's wrong

If I do

Code:

$this->db->where('MATCH (field) AGAINST ("value")', FALSE);
$this->db->get('table');

The generated query is

SELECT * FROM (`table`) WHERE MATCH (field) AGAINST ("value") 0

(note the 0 at the end).

Have you tried it?