Query runs OK outside of CI, but not in.

[eluser]richard_ctv[/eluser]
This one has really got me scratching my head. I am sending a big long query into CI:

Code:

SELECT *
FROM item
WHERE MATCH title,short_desc,long_desc,participants,keywords,transcript
AGAINST ('+governance' IN BOOLEAN MODE) LIMIT 1000;

as part of a search page, via $this->db->query().

It returns no valid rows, yet the same query run directly in mysql returns the expected row.

If I do this:

Code:

var_dump( mysql_result( $result->result_id, 0, 'title'));

to look at the mysyl result id, it also returns expected data.

Being new to CI I'm sure I'm missing something here, but I don't know what...

(The reason I am not using a bunch of ->where() ->limit() statements is that I have a solid pre-existing class - set up as a library - that splits up the search terms and generates the query based on the tables field data).