Mysql select true or false

SELECT IF(count(*) > 0, "yes", "no") AS output FROM users WHERE name="admin";
# output = "yes" or "no" 
SELECT IF(count(*) > 0, 1, 0) AS output FROM users WHERE name="qwerty";
# output = 1 or 0

Similar codes

0 vote172 views1 answer
Plpgsql raise notice
SQL
0 vote186 views1 answer
Like date sql server not working
SQL
0 vote168 views1 answer
Update table sql multiple set
SQL
1 vote174 views1 answer
Oracle split string
SQL
0 vote178 views1 answer
Nosql vs sql
SQL
4 votes170 views2 answers
Oracle default date format
SQL
0 vote186 views1 answer
Hierarchal database table
SQL
0 vote178 views1 answer
Mariadb maximum left join
SQL
12 votes157 views4 answers
Mysql get date difference in hours
SQL
6 votes216 views2 answers
How to get last element sql
SQL