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: 423

Filed under:
|
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

Related posts about sql

Related posts about mysql