Member Avatar for werks

Hello experts could someone tell me how can i combine multiple records into one value.

Sample in MS Access:
(Lastname & "" & "," & " " & Firstname) AS Name

How can i do this in MySQL?..tnx in advance

  • 2 Contributors
  • 3 Replies
  • 92 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by nav33n

Recommended Answers

All 3 Replies

Member Avatar for nav33n

concat(firstname,lastname) as name More on concat here.

Member Avatar for werks

Thanks! your a great help!

Member Avatar for nav33n

:) you are welcome.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.