Select from table with multiple values

My query is

SELECT  *
FROM    tblalumni_member
WHERE   username IN ( SELECT    *
                      FROM      开发者_运维技巧Split('ramesh,sagar,pravin', ',') )
        AND Is_Approved = 1

and username field contains multiple values separated by comma. Like ramesh,sachin,pravin.

It should give all rows if any of get matched in selected result.

Can you please help me?

---

In case of SQL Server perhaps something like

SELECT *
FROM   tblalumni_member m
WHERE  Is_Approved = 1 AND
       EXISTS(
            SELECT * FROM Split(m.username, ',')
          INTERSECT
            SELECT * FROM Split('ramesh,sagar,pravin', ',')
       )