0

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

2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by sanjaypandit
0

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

0

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

Edited by peter_budo: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.