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
Thanks in advance.