Page 1 of 1

3 fields together as one definition.

Posted: Fri Dec 26, 2003 3:21 am
by anjanesh
MySQL:
I have a table students with some number of fields. 3 of them are firstname, middlename, lastname. roll is another field.
I want to define name such that
select name from students where roll='123';
should give the same result as
select firstname,middlename,lastname from students where roll='123';
Thanks

Posted: Fri Dec 26, 2003 7:12 am
by aquila125
CONCAT is your friend!