how to return boolean using mysql EXISTS

Question

I want to get a boolean output to a mysql query.

i issue a query like the following

EXISTS (
    select 1 
    from someothertable 
    where someaccid = (
       select someid 
       from smtable 
       where username = 'someuser' 
       and password = 'somepassword')
)

This returns an error 1064 in the mysql shell and returns a bool false in php mysqli .

How can i get an output as bool using EXISTS command?

Thanks in advance.

Giorgos Betsos · Accepted Answer · 2015-06-11 10:58:35Z

13

Use SELECT:

SELECT EXISTS (select 1 
               from someothertable 
               where someaccid = (select someid 
                                  from smtable 
                                  where username = 'someuser' and 
                                        password = 'somepassword'))

This will return 1 if EXISTS is successful, 0 otherwise.

answered Jun 11, 2015 at 10:58

Giorgos Betsos

72.3k10 gold badges69 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to return boolean using mysql EXISTS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related