Consult concatenated column

Question

Consult concatenated column

Navigation

#1 by (2 votes)
#2 by (1 votes)
#3 by (1 votes)

0

I have the following sql query that works fine.

 SELECT
    C.id AS id,
    concat(C.apellido_paterno," ",C.apellido_materno," ",C.nombres) AS 
    nombre_completo,
    C.agente AS agente,
    G.genero AS genero
    FROM cliente_tabla AS C
    JOIN genero_tabla AS G ON G.id = C.genero

But when I try to make the following query

  SELECT
    C.id AS id,
    concat(C.apellido_paterno," ",C.apellido_materno," ",C.nombres) AS 
    nombre_completo,
    C.agente AS agente,
    G.genero AS genero
    FROM cliente_tabla AS C
    JOIN genero_tabla AS G ON G.id = C.genero 
    WHERE nombre_completo LIKE "%PACO%"

throw Unknown column 'full_name' in 'where clause'

sql

asked by jufrfa 08.11.2017 в 18:45

source

3 answers

2

One option is to do:

select *  from ( SELECT
    C.id AS id,
    concat(C.apellido_paterno," ",C.apellido_materno," ",C.nombres) AS 
    nombre_completo,
    C.agente AS agente,
    G.genero AS genero
    FROM cliente_tabla AS C
    JOIN genero_tabla AS G ON G.id = C.genero ) as OTRATABLA 
where  OTRATABLA.nombre_completo LIKE "%PACO%" ;

answered by 08.11.2017 в 20:05

1

Since I see two previous answers that are correct, I just wanted to tell you that it is more convenient to use concat_ws like this:

select concat_ws(" ",C.apellido_paterno,C.apellido_materno,C.nombres) AS nombre_completo from cliente_tabla

I hope I have been helpful

answered by 09.11.2017 в 13:16

Datepicker Dates - Do not open Calendar how can it be done so that when you click on a menu icon it changes to another icon?

score 1 · Accepted Answer

You can not put an alias in a where you have to put back the full concat

SELECT
    C.id AS id,
    concat(C.apellido_paterno," ",C.apellido_materno," ",C.nombres) AS 
    nombre_completo,
    C.agente AS agente,
    G.genero AS genero
    FROM cliente_tabla AS C
    JOIN genero_tabla AS G ON G.id = C.genero 
    WHERE concat(C.apellido_paterno," ",C.apellido_materno," ",C.nombres) LIKE "%PACO%"