Advertisement
Guest User

Untitled

a guest
Oct 9th, 2015
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. +------+------+------------+-------------+
  2. | id | lang | contentUrl | contentType |
  3. +------+------+------------+-------------+
  4. | CON1 | en | test/path | hls |
  5. | CON1 | en | test/path | mp4 |
  6. | CON3 | en | test/path | mp4 |
  7. | CON3 | fr | test/path | mp4 |
  8. | CON2 | en | test/path | mp4 |
  9. +------+------+------------+-------------+
  10. 5 rows in set (0.00 sec)
  11.  
  12. query is: get all content for language (fr) with content (hls). It returns all defaults for (en) and (mp4) as well. Now I have to choose which one to return??? Each ID needs to be present once.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement