Styjun

How to befriend someone who doesn't like to talk?

C++ logging library

Is Jesus the last Prophet?

Suppose leased car is totalled: what are financial implications?

Part of my house is inexplicably gone

A life of PhD: is it feasible?

When to use и or а as “and”?

How to show a "node near coord" even when it is out of bounds (with clip = true)?

Parsing text written the millitext font

What is the STRONGEST end-of-line knot to use if you want to use a steel-thimble at the end, so that you've got a steel-eyelet at the end of the line?

Why do the TIE Fighter pilot helmets have similar ridges as the rebels?

What does the homotopy coherent nerve do to spaces of enriched functors?

How to avoid typing 'git' at the begining of every Git command

Why does there seem to be an extreme lack of public trashcans in Taiwan?

Entered UK using my now-lost UK passport; can I go to Spain using my US passport?

What to bootstrap for hypothesis testing

Grandpa has another non math question

Can I use 220 V outlets on a 15 ampere breaker and wire it up as 110 V?

How many sets of dice do I need for D&D?

Why do (or did, until very recently) aircraft transponders wait to be interrogated before broadcasting beacon signals?

Make Gimbap cutter

In The Incredibles 2, why does Screenslaver's name use a pun on something that doesn't exist in the 1950s pastiche?

What is the theme of analysis?

Oil draining out shortly after turbo hose detached/broke

Search where concat name after select in mysql query

How do I quickly rename a MySQL database (change schema name)?Using mysql concat() in WHERE clause?How to output MySQL query results in CSV format?MySQL “NOT IN” queryMySQL select with CONCAT conditionMySQL CONCAT(“string”,longtext) results in hex stringHow to search for a full name when first name and last name are stored in a different columnsYii2 Gridview merge two columnsMysql Concat two columns while searching with LIKEDjango Queryset for concat query fullname of first_name and last_name

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have a table with several columns generated from a mysql query. One is merged using concat 'first_name' and 'last_name' making the column 'username'. All the columns can be individualy filtered.

So I was wondering if a concat value could be filtered after it has been selected in a query. So something like...

->selectRaw('CONCAT(first_name, " ", last_name) AS username')
->where('username', 'LIKE', '%search_username%')

I understand I could do something like.

->where(DB::raw("CONCAT(first_name, " ", last_name) LIKE '%search_username%")

But I have done a loop which goes through all the search columns and differentiates between a column name or concat value.

foreach ($search->filters as $key => $value) 
 // Check for column search
 if($value->type === 'column')
 $query->where($value->name, 'LIKE', "%$value->text%");
 
 // Check for concat search
 if($value->type === 'concat')
 $query->where(?);
 

mysql where concat

share|improve this question

asked Mar 24 at 22:54

PaulPaul

385

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If you end up doing SQL in loops you're probably doing the wrong thing. A generated column being the CONCAT. Potentially use a FT index rather rthan LIKE '%xx%. FT search engines like Solr, Sphinx, Lucene do searches better than MySQL.
  
  – danblack
  Mar 25 at 0:47
  

  
  
  
  

add a comment | 

0

I have a table with several columns generated from a mysql query. One is merged using concat 'first_name' and 'last_name' making the column 'username'. All the columns can be individualy filtered.

So I was wondering if a concat value could be filtered after it has been selected in a query. So something like...

->selectRaw('CONCAT(first_name, " ", last_name) AS username')
->where('username', 'LIKE', '%search_username%')

I understand I could do something like.

->where(DB::raw("CONCAT(first_name, " ", last_name) LIKE '%search_username%")

But I have done a loop which goes through all the search columns and differentiates between a column name or concat value.

foreach ($search->filters as $key => $value) 
 // Check for column search
 if($value->type === 'column')
 $query->where($value->name, 'LIKE', "%$value->text%");
 
 // Check for concat search
 if($value->type === 'concat')
 $query->where(?);
 

mysql where concat

share|improve this question

asked Mar 24 at 22:54

PaulPaul

385

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If you end up doing SQL in loops you're probably doing the wrong thing. A generated column being the CONCAT. Potentially use a FT index rather rthan LIKE '%xx%. FT search engines like Solr, Sphinx, Lucene do searches better than MySQL.
  
  – danblack
  Mar 25 at 0:47
  

  
  
  
  

add a comment | 

I have a table with several columns generated from a mysql query. One is merged using concat 'first_name' and 'last_name' making the column 'username'. All the columns can be individualy filtered.

So I was wondering if a concat value could be filtered after it has been selected in a query. So something like...

->selectRaw('CONCAT(first_name, " ", last_name) AS username')
->where('username', 'LIKE', '%search_username%')

I understand I could do something like.

->where(DB::raw("CONCAT(first_name, " ", last_name) LIKE '%search_username%")

But I have done a loop which goes through all the search columns and differentiates between a column name or concat value.

foreach ($search->filters as $key => $value) 
 // Check for column search
 if($value->type === 'column')
 $query->where($value->name, 'LIKE', "%$value->text%");
 
 // Check for concat search
 if($value->type === 'concat')
 $query->where(?);
 

mysql where concat

share|improve this question

asked Mar 24 at 22:54

PaulPaul

385

->selectRaw('CONCAT(first_name, " ", last_name) AS username')
->where('username', 'LIKE', '%search_username%')

->where(DB::raw("CONCAT(first_name, " ", last_name) LIKE '%search_username%")

foreach ($search->filters as $key => $value) 
 // Check for column search
 if($value->type === 'column')
 $query->where($value->name, 'LIKE', "%$value->text%");
 
 // Check for concat search
 if($value->type === 'concat')
 $query->where(?);
 

share|improve this question

asked Mar 24 at 22:54

PaulPaul

385

share|improve this question

asked Mar 24 at 22:54

PaulPaul

385

asked Mar 24 at 22:54

PaulPaul

385

asked Mar 24 at 22:54

PaulPaul

385