< table > < thead > < tr > < th > now the query result in mysql has the following columns. You want it to output "adv.". Choose between the two, otherwise, or "how do you write this sql? < / th > < / tr > < / thead > < tbody > < tr > < td > pid < / td > < td > ID < / td > < td > pos < / td > < td > cn < / td > < / tr > < tr > < td > 890 < / td > < td > 305 < / td > < td > adv. < / td > < td > choose between the two < / td > < / tr > < tr > < td > 891 < / td > < td > 305 < / td > < td > adv. < / td > < td > otherwise < / td > < / tr > < tr > < td > 892 < / td > < td > 305 < / td > < td > adv. < / td > < td > or < / td > < / tr > < / tbody > < / table >