3 fields together as one definition.
Posted: Fri Dec 26, 2003 3:21 am
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
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