Setting a query result literal in Laravel query builder?

Question

I am trying to set a column result literal with the Laravel query builder. By writing raw SQL I would achieve this with:

SELECT
  `field1`, 
  `field2`, 
  'Test' AS `field3` 
FROM `Test`;

Therefore MySQL will always return Test for column field3. I'm trying to do this with the query builder like select('field1', 'field2', '"Test" AS field3') but this doesn't seem to work. It will return an error that Test is not a column name.

Does anyone have an idea how I could do this?

@Raphael_ No, he wants the string Test to be always the value of field3 (which might not even exist). — ceejayoz
– ceejayoz, Commented Oct 22, 2014 at 0:21

rmobis · Accepted Answer · 2014-10-21 23:43:39Z

8

You want the DB::raw() function:

->select('field1', 'field2', DB::raw("'Test' AS field3"))

edited Oct 21, 2014 at 23:43

rmobis

27.1k8 gold badges72 silver badges69 bronze badges

answered Oct 21, 2014 at 23:43

ceejayoz

181k42 gold badges311 silver badges382 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Setting a query result literal in Laravel query builder?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related