How to count there is no specific character in a string in mysql

Question

I have a table with a row with data like '/2323/3235/4545/222/', how can I count the number / in each row using only mysql.

+5

Ankit sharma May 11 '12 at 8:46

2 answers

SELECT LENGTH('/2323/3235/4545/222/') - LENGTH(REPLACE('/2323/3235/4545/222/', '/', '')) AS `occurrences`

+3

MIT May 11 '12 at 8:59

JK. · Accepted Answer · 2012-05-11T08:50:19+0000

A quick search came up with the following:

SELECT LENGTH('/2323/3235/4545/222/') - LENGTH(REPLACE('/2323/3235/4545/222/','/','')) ... etc;