match a value

[rupam_jaiswal]

Hi,
My table is like this

Id,Name,Location,Hobby

Condition is
- if location is 1 then possible values of Hobby can be a1,a2,a3,a4,a5
- if location is 2 then possible values of Hobby can be b1,b2,b3,b4,b5
- if location is 3 then possible values of Hobby can be c1,c2,c3,c4,c5
- if location is 4 then possible values of Hobby can be d1,d2,d3,d4,d5

Now I have to get the row whose hobby value is suppose a1.
How can I do this.I can't use like operator a1% as a100 will match then
Regards

[CoderDan]

Can you be a little more specific?
What is some actual sample data?
what row(s), out of this sample data, might you want to 'get'?
How do these conditions actually apply - is it intended to limit what data can be inserted?