multi value mysql code example

Example: multi value column mysql

select * from celebrities 
where professions='002'          -- The only item in the list
or    professions like '002 %'   -- it might be first of several
or    professions like '% 002'   -- it could be the last of several
or    professions like '% 002 %' -- or in the middle