SELECT * from photoinfo

SELECT * from photoinfo where find_in_set('decade2000',setnames) order by photo limit 5
5 rows returned for where find_in_set('decade2000',setnames) order by photo limit 5
photo01Downtownsignkja.jpg width height
datemodified dateadded
setnames
caption

photo01_civic_theatre.jpg width height
datemodified dateadded
setnames
caption

photo01toddwatchespattismithconcertweert071004.jpg width height
datemodified dateadded
setnames
caption

photo02Downtownsignkja.jpg width height
datemodified dateadded
setnames
caption

photo02_Webster_050704_kja.jpg width height
datemodified dateadded
setnames
caption