I have a table named `Garden`.

In the `Garden` table there is column named `Fruit` with thousands of rows
and each row of `Fruit` has comma seperated values like `Apple`, `Banana`, `Pear` and so on.

I want the get the count of the number fruits in each row in `Fruit` column
like if first row has `Apple`, `Banana`, `Pear`, then the count should return 3.

How to write a sql query for it.

I tried using regex but its not working.