Calculate string occurences

Moki Lv6
  2022-10-21 08:28:28 2022-10-21 08:28:28 Created   2022-10-21 08:28:28 2022-10-21 08:28:28 Updated   
1
2
3
SET @str='1,2,3,4,5';
SET @separator=',';
SELECT (LENGTH(@str) - LENGTH(REPLACE(@str, @separator, '')) / LENGTH(@separator))+1;
Recommendations
Temporary disable write to binlog Temporary disable write to binlog Eval MySQL/MariaDB Eval MySQL/MariaDB C++ - convert string/numerics C++ - convert string/numerics
Recommendations
Temporary disable write to binlog Temporary disable write to binlog Eval MySQL/MariaDB Eval MySQL/MariaDB
On this page
Calculate string occurences