You have at least 2 options (witch came instantly in my mind):
CONCAT_WS - concatenation with separator
SELECT CONCAT_WS('/', firstname, lastname) AS name FROM tablename
CONCAT - concatenation of arguments
SELECT CONCAT(firstname, SPACE(1), lastname) AS name FROM tablename
ATTN: SPACE(n) - gene
Hello NG,
I have two tables, three and four fields inside, in my mysql database,
created with phpmyadmin:
t_authors
1 authorid (primary key, auto_increment)
2 lastname
3 firstname
t_books
1 bookid (primary key, auto_increment)
2 authorid (Typ:index, reference to t_authors.authorid, done
with p
