LordOfLA
Godlike!
- Joined
- 2 Feb 2004
- Messages
- 7,026
Hey!
Anyone know if I can have mysql 5 arbitrarily prefix a value from a table in a select statement?
I had thought that something like:
would do the trick but I just get nothing out of mysql.
Pointers in the right direction would be appreciated
Anyone know if I can have mysql 5 arbitrarily prefix a value from a table in a select statement?
I had thought that something like:
Code:
SELECT CONCAT('maildir:',pop) AS home FROM users WHERE username = "email@domain.com"
would do the trick but I just get nothing out of mysql.
Pointers in the right direction would be appreciated