Is it possible to edit the contents of fields after a select statemen? For example, I have a table Person (Id int, Username varchar(50)). Most of the rows in Username has the format of, say for example, aaa_01, bbb_02. I want to select this usernames with the underscores and the numeric parts ommited (Say for aaa_01, it will output aaa only). Is this possible in mysql?
Thanks guys.