Spark SQL equivalent of SQL IN Condition

Question

Im new on Spark, I need help on how I can use IN Condition in sparkSQL

SELECT name,age WHERE age IN (25,35,45) FROM table

Answer 1

This should work df.where(col('age').isin([25, 35, 45)).select('name', 'age')

For reference, see the spark documentation