what i want a sql query to search employee details from the table 'emp_table'.
A field 'mem_fld' contains the value seperated with commas( eg:- 2,4,9,) will have n numbers. My search input is an array eg:-$arrayvar[0]=7,$arrayvar[2]=9,......n values.I have to list the records from the table matching with the input array values.?
thanks in advance.

You can do it with regex matching functions, but it won't be very efficient. A better way would be to put the field with comma separated values in a different table and then search for records.

You mean, something like this:

select someColumn
from tableX
where columnValue in (2, 4, 9, 12, 45)