I want to integrate like functionality in iOS/android app. I am developing service for that. My question is : I have table called songs in which I have song details
**like**
song
song_id
station_id
song_file
so on. I have second table called userlike where user like inforamation are stored.
**userlike**
user_id
song_id
like
My main problem is that I want to return all song details with like value information for particular user.If uer has not like it then I may send 'zero' or null in my JSON. How to build this query? I need song data and like value if user has liked it.