sql search comma separated string in comma seperated string code example

Example: search from comma separated values in sql server

WHERE tablename REGEXP "(^|,)@search(,|$)"