I have column in table views: 165,75,44,458,458,42,45
This column contain user\_ids who viewed a link.
I want to explode it by comma delimiter and count the ids

I tried this but it only counts all the character.

SQL:

```
SELECT LENGTH(views) FROM questions WHERE question_id=1;

```

This is the PHP version that I want to do in SQL

```
$viewers_ids  = "165,75,44,458,458,42,45";
$num_of_views = count(array_filter(explode(",", $viewers_ids)));

```