Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

New answers tagged

0

Your second select query does what you want ... - deliver all imageupload entries - together with who took it and where / when - and who marked it favorite ... I suggest you put a proper alias for favorites.uid to make it more prominent http://sqlfiddle.com/#!9/b04a03/4 SELECT CASE WHEN favorites.uid=1 THEN 1 ELSE 0 END AS `my_favorite`,...


Top 50 recent answers are included