SQL query in Laravel

Question

SQL query in Laravel

Navigation

#1 by (1 votes)
#2 by (0 votes)

1

How can I pass the following query in Laravel 5.4

SELECT CONCAT( 
  TRIM(SUBSTRING(NombreCliente,1,1)),  
  TRIM(SUBSTRING(NombreCliente, locate( ' ',NombreCliente), 2) ) 
)INICIALES FROM 'cliente'

sql laravel eloquent laravel-5

asked by arch 14.06.2018 в 22:49

source

2 answers

Modify the css of an entire row when checking how to send a data from a recyclerView to an Activity? How to return this data to the recyclerView if it is modified in the activity?

score 1 · Answer 1

Try simply putting your custom selection within select of Query Builder :

  $result = DB::table('cliente')
            ->selectRaw("CONCAT( TRIM(SUBSTRING( NombreCliente,1,1) ), TRIM(SUBSTRING( NombreCliente, locate( ' ',NombreCliente), 2) ) ) INICIALES")
            ->get();

To learn more about Query Builder here official documentation link .

score 0 · Answer 2

0

Solution:

$result = DB::table('cliente')
      ->select(DB::raw("CONCAT( TRIM(SUBSTRING( NombreCliente,1,1) ), TRIM(SUBSTRING( NombreCliente, locate( ' ',NombreCliente), 2) ) ) AS INICIALES"))
      ->get();

answered by 15.06.2018 в 00:53