Select in php display

Question

$sqlQuery = "SELECT username as display_name, fullname as full_name, email as email, role as administrators, status as be_on FROM admin";

record role:0,1,...

I want the role of the administrators will display 1 is admin and if equal to 0 , then show the user.

Who can help me?

Answer 1

I think your look for the IF statement

SELECT IF(`admin`.`role`= 1,TRUE,FALSE) FROM ...

http://www.mysqltutorial.org/mysql-if-function.aspx