what is the purpose of this mysql query ?
Posted
by
Harbhag
on Stack Overflow
See other posts from Stack Overflow
or by Harbhag
Published on 2010-12-25T12:31:48Z
Indexed on
2010/12/25
12:54 UTC
Read the original article
Hit count: 459
SELECT id, CONCAT(lastname,', ',firstname) AS fullname, lastname, firstname
FROM " . TABLE_CONTACT . "
WHERE
CONCAT(firstname,' ', lastname) LIKE '%$goTo%' OR
CONCAT(firstname,' ', middlename,' ', lastname) LIKE '%$goTo%' OR
nickname LIKE '%$goTo%'
ORDER BY fullname";
Can anyone please tell me what is purpose of above query ? I am new to mysql so unable to understand it. Thanks
© Stack Overflow or respective owner
