error in running query

Question

where h.er = select ( p.er from tip p where p.os = 'Android' OR 'iOS' ) AND h.ssn = (select h2.ssn  from persons h2 where h2.ssn like '213%');

I am performing this function in mysql. IT is not letting me to do it. An error is coming like check the manual the mysql version cooresponds to. I am using 5.1.5.1 MYsql

Answer 1

Try putting the select inside the parenthesis as:

where h.er = ( select p.er fr...
             ^

Answer 2

Try replacing:

where p.os = 'Android' OR 'iOS' 

With:

where p.os = 'Android' OR p.os = 'iOS' 

Or:

where p.os IN ('Android', 'iOS')