match a value
 

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

What is your query so far? and can you post your schema?

could always do an EAV data scheme