Re: Funcion INSTR

[Fabio Castillo]

Thank you Dmitry Tolpeko for you help

Follow your example if i have this data

mysql> select * from t2;
+---------+
| c1 |
+---------+
| 1,2,3 |
| 1 |
| 2 |
| 1,1 |
| 1,2 |
| 1,3 |
| 1,1,1 |
| 1,1,3 |
| 1,1,4 |
| 1,2,2,1 |
| 1,2,2,2 |
| 1,2,8,1 |

I need to know the number of occurrences of ',' in each row
Result of the query would be as follows:

+---------++-----------+
| c1 |occurre |
+---------+------------+
| 1,2,3 |2
| 1 |0
| 2 |0
| 1,1 |1
| 1,2 |1
| 1,3 |1
| 1,1,1 |2
| 1,1,3 |2
| 1,1,4 |2
| 1,2,2,1 |3
| 1,2,2,2 |3
| 1,2,8,1 |3

in oracle is

SELECT c1, INSTR(C1,',',1,2) FROM t2;

in Mysql is?
help me please