Mysql sorgusunda concat ()

0 Cevap php

im mysql sorguda dizesinin bir sorunu yaşıyor.

burada benim sorgu:

SELECT *, CONCAT(nombre,' ',apellido) AS fullname FROM user WHERE nombre LIKE '%$busqueda%' OR apellido LIKE '%$busqueda%' OR email LIKE '%$busqueda%' OR about LIKE '%$busqueda%' OR place LIKE '%$busqueda%' or fullname LIKE '%$busqueda%'

however the query fails: Query failed: Unknown column 'fullname' in 'where clause'

Proabably sadece bir sözdizim hata, thx

0 Cevap