search from array

[sanjaypandit]

i want to search from the following table attached in zip file,

my query is
select * from tbl_property where acco_id='1' and count_id='1' and holi_id='1' order by add_date desc

but there is a problem, i have various value in holi_id , i want to search , means want to match from one of the value of holi_id

[blocblue]

Hey,

Surely a modified query such as:

select * from tbl_property where acco_id='1' and count_id='1' and holi_id in ( '1', '2', '3', '...' ) order by add_date desc

would allow you to search for multiple values in a single field??

R

[sanjaypandit]

sorry i can not explain better , but if u see the table
we have following query

select * from tbl_property where acco_id='1' and count_id='1' and holi_id = '1' order by add_date desc

now result should be received in two row.

because there are two rows one have
acco_id=1,
holi_id=1,3,5
count_id=1

another one hve
acco_id=1,
holi_id=1
count_id=1

i want both result after searching, main problem in first row, where holi_id have more than one value, i want to check one value from these 3 value