Sql

Search

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: how to drop function in sql
Sql :: 1396(hy00) mysql error
Sql :: ValueError: A string literal cannot contain NUL (0x00) characters.
Sql :: sql sum by column
Sql :: kill session inactive oracle
Sql :: sql #region
Sql :: codigo crear tablas sql server
Sql :: What is dialect for Postgres
Sql :: sql line numbers
Sql :: sqlite save db
Sql :: how to install sql in anaconda
Sql :: declarative base sqlalchemy
Sql :: change filed order in mysql
Sql :: json query
Sql :: sql server insert into table
Sql :: Postgres - Login and connect as default user
Sql :: primary key multiple colums
Sql :: failed to connect to mysql at localhost:3306 with user root
Sql :: postgresql get date from datetime
Sql :: mysql delete database
Sql :: osx stop mysql service
Sql :: show sql server database
Sql :: sql log file inof
Sql :: mysql select row with min date
Sql :: oracle alter table add column default value
Sql :: create table as select * from table mssql
Sql :: htaccess allow index
Sql :: find all tables with column name
Sql :: to_char sql
Sql :: rollback in sql

Search

SQL

mysql select true or false

ADD CONTENT