MySQL controle flow and string functions support

Yii 2.0 General Discussions
1

Can we use control flow and string functions like IFNULL() and FIND_IN_SET() from MySQL in ActiveRecord without using raw SQL?

For example if I want to use FIND_IN_SET() string function in WHERE clause I don’t see any possible way from Documentation.

Similarly I couldn’t find way to use IFNULL() control function in my SELECT clause.

Any pointers or examples would be much appreciated.

Thanks.