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 vote164 views1 answer
Mysql workbench search all tables
SQL
0 vote257 views1 answer
Mysqlimport
SQL
0 vote275 views1 answer
Mysql disable triggers
SQL
0 vote210 views1 answer
Postgres can integer fields be negative
SQL
1 vote200 views1 answer
How to change owner in postgres
SQL
0 vote204 views1 answer
Mysqldump ignore table
SQL
1 vote259 views1 answer
Sql server locks
SQL
5 votes260 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote225 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
0 vote194 views1 answer
Shrink database file in sql server
SQL