SitePoint Sponsor

User Tag List

Results 1 to 1 of 1
  1. #1
    SitePoint Addict jpease's Avatar
    Join Date
    Jul 2002
    Location
    In the network.
    Posts
    217
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL Query Join / CONCAT Syntax Question

    I have a MySQL DB where I have no control over the data.

    I would like to do something like the following, but haven't been able to track down the correct syntax (or whether it is possible).

    SELECT ..... WHERE tableA.Name = (tableB.lastName, tableB.firstName) ...



    EDIT: GOT IT WORKING

    SELECT ... WHERE (tableA.Name = CONCAT(tableB.lastName, ", ", tableB.firstName)) ...
    Last edited by jpease; Mar 13, 2005 at 12:27.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •