5 replies

Select EXISTS

How to query boolean value if row exists or not. In pure sql it will be like this:

SELECT EXISTS(SELECT 1 FROM your_table_name WHERE id = 1 AND version = 5)

SELECT EXISTS(SELECT 1 FROM your_table_name WHERE id = 1 AND version = 5)

Select EXISTS - Drizzle Team