How do you do a MySQL FULLTEXT search in DMZ?

[eluser]TaylorOtwell[/eluser]
If anyone has ever done this successfully please post an example. Thanks!

[eluser]WanWizard[/eluser]
There isn't a ready made method for that, but since using it ties you to MySQL, just use a direct query, like you would do in CI?
You can do this in a model method if you wish (just use $this->db like you're used to in CI).

[eluser]TaylorOtwell[/eluser]
Wan,

How can I do it such that DataMapper still populates my objects and my one-to-one relationships (I have DMZ set to always populate 1:1 relationships)?

I guess there is no way to just pass a hand written "where" clause into DMZ?

[eluser]WanWizard[/eluser]
The DMZ where() method follows the same rules as CI's one. So you can use FALSE as third parameter to prevent escaping, so you can pass custom where clauses.
Alternatively you can use the query() method to compose your own query. Datamapper will still process the relations.