How to use mapper to execute SQL?

[Gosforth]

I have code:

$this->db = \Registry::get('DB');

$mapper = new \DB\SQL\Mapper($this->db,'table');

Then SQL:

SELECT * FROM table WHERE MATCH (name, code) AGAINST ('some text' IN BOOLEAN MODE);

How to execute this SQL?

Regards

[ikkez]

Hi. Just assign this as a filter

$this->db = \Registry::get('DB');
$mapper = new \DB\SQL\Mapper($this->db,'table');

$text = 'some text';
$mapper->find(["MATCH (name,code) AGAINST (:search IN BOOLEAN MODE)", ':search' => $text ]);

If you also want to sort the results by relevance, you need to add this match as adhoc field like this:

$mapper->relevance = "MATCH (name,code) AGAINST (:search1 IN BOOLEAN MODE)";
$mapper->find(["MATCH (name,code) AGAINST (:search2 IN BOOLEAN MODE)", ':search1' => $text, ':search2' => $text ], ['order'=>'relevance desc']);

now cross the fingers and hope it works ;)

[Gosforth]

Thank you Ikkez!!