how to use ALL clause in mysql

Question

i trying to fetch records from database as.

select * from emp_marks where sub_id all(2,4);

Answer 1

you can't use all with where clause, if you want to get all the records that have sub_id = 2 or 4 you can use:

select * from emp_marks where sub_id in (2,4)

Answer 2

If you want the records where sub_id is either 2 or 4, you need

SELECT * FROM emp_marks WHERE sub_id IN (2,4);

if you want to records where sub_id is both 2 and 4, you don't have to perform query at all ;-)