This one has really got me scratching my head. I am sending a big long query into CI:
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:
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).
