id date projectid modulename del flag
1 2012-01-12 ,63, ,197,204,400, 0
2 2012-01-13 ,64, ,100,200, 0
3 2012-01-14 ,65, ,197,205,40, 1
4 2012-01-15 ,63, ,103,197, 0
5 2012-01-16 ,62, ,, ,197,204,400, 1
6 2012-01-17 ,61, ,1,20, 0
7 2012-01-18 ,63, ,19,204,410, 0
8 2012-01-19 ,633, ,100,200, 0
9 2012-01-20 ,64, ,197,,20 0
10 2012-01-21 ,630, ,100,200,197 0
i want to find record whose modulename =197 and delflag=0 that means wherever 197 record are found and delflag=0
that record i want to show. please give me the query