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
3 fields together as one definition.
Moderator: General Moderators