How to get this done in mysql?
- by bala3569
Consider i have a registartion table and there is field prefLocationId and it contains value like this 1,2,3,2,1,4 and so many.... And i have a table prefLocation which looks like this
Id LocationName
1 Chennai
2 Mumbai
3 Kolkatta
4 Delhi
and i want to select record of users and show values like
Chennai,Mumbai,Kolkatta,Mumbai,Chennai,Delhi and so on...