4

How can I addSelectRaw() in order to bind my variables to addSelect()?

I've got this in my code:

$query->addSelect( DB::raw('MATCH(matchy.val) against ("'.addslashes($q).'") as relevance ') );

addslashes() is far less than ideal, and i should be binding to a ? instead. How can I do addSelectRaw() instead?

iateadonut
  • 1,951
  • 21
  • 32

1 Answers1

8

selectRaw() behaves like addSelect already - selectRaw() actually adds the columns.

you can just do this:

$query->selectRaw('MATCH(matchy.val) against (?) as relevance ', [$q] );

(When I was searching for the answer to this question, I duckgo'ed 'laravel addselect' and couldn't find anything, so I decided to post this and answer my own question.)

iateadonut
  • 1,951
  • 21
  • 32