MySQL SUBSTRING_INDEX in CI 2.1.0

[eluser]Unknown[/eluser]
Hi everybody,

I come from downloading the latest CI version 2.1.0 and I'm having an issue with this piece of a query

Code:

$this->db->select('SUBSTRING_INDEX(text, " ", 200) as text');

that is resulting in this error:

... SUBSTRING_INDEX(text, `"` ", `200)` as text FROM ... into the final query

I've tried to escape the "" and to use '' instead but doesn't works

Any suggestion?

Thanks