find value in comma separated string

 POSTGRESQL 

SELECT * FROM uploaded_data join WHERE '18' = any(string_to_array(user_id, ',')) 

With laravel

 $user_data = DB::select("SELECT id FROM uploaded_data WHERE '".Auth::user()->id."' = any(string_to_array(user_id, ',')) ");

 $user_data=collect($user_data)->pluck('id')->toArray();

 $data = UploadedData::whereIn('id', $user_data)->latest()->with('dataType')->with('state')->get();

MYSQL

$data = UploadedData::whereRaw('FIND_IN_SET(?, user_id)', [Auth::user()->id])->latest()->with('dataType')->with('state')->get();