CONCAT columns with Laravel 5 eloquent

by

You need to wrap your query in DB::raw:

$comp = Component::select(DB::raw("CONCAT('name','id') AS ID"))->get()

Also, note because you are doing your query like this, your model might behave differently, because this select removes all other fields from the select statement.
So you can’t read the other fields from your model without a new query. So ONLY use this for READING data and not MODIFYING data.

Also, to make it in a nice list, I suggest you modify your query to:

$comp = Component::select(DB::raw("CONCAT('name','id') AS display_name"),'id')->get()->pluck('display_name','id');
// dump output to see how it looks.
dd($comp);// array key should be the arrray index, the value the concatted value.

More Related Contents:

  1. Laravel 5 PDOException Could Not Find Driver
  2. Laravel-5 ‘LIKE’ equivalent (Eloquent)
  3. How can I solve incompatible with sql_mode=only_full_group_by in laravel eloquent?
  4. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  5. Laravel 5.5 Error Base table or view already exists: 1050 Table ‘users’ already exists
  6. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  7. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  8. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
  9. How can I do a migration in laravel 5.5?
  10. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  11. find in set in laravel ? example
  12. How to update multiple MySQL table entries with different id?
  13. Can’t insert data into mysql database using PHP [closed]
  14. which is better every user have a table or just a row [closed]
  15. How can I use PDO to fetch a results array in PHP?
  16. How to validate array in Laravel?
  17. MySQL check if a table exists without throwing an exception
  18. Calculate age based on date of birth
  19. How to write a stored procedure using phpmyadmin and how to use it through php?
  20. Doing calculations in MySQL vs PHP
  21. Geo-Search (Distance) in PHP/MySQL (Performance)
  22. PHP mysql search multiple tables using a keyword
  23. Laravel 5.4 redirection to custom url after login
  24. Laravel Route issues with Route order in web.php
  25. Best practice: Import mySQL file in PHP; split queries
  26. Connecting to remote MySQL server using PHP
  27. Using PHP to execute multiple MYSQL Queries
  28. Base table or view not found: 1146 Table Laravel 5
  29. How to run multiple insert query in SQL using PHP in one go?
  30. laravel 5 : Class ‘input’ not found

Leave a Comment