Count number of specific character in string (MySQL)

Alle records met één spatie in het veld "name_30":

use bb_dwh;

select 
	name_30 
from 
	root
where
	length(name_30)-length(replace(name_30, " ", ""))=1;

Of met twee spaties in het veld "name_30":

use bb_dwh;

select 
	name_30 
from 
	root
where
	length(name_30)-length(replace(name_30, " ", ""))=2;

Bronnen

• https://stackoverflow.com/questions/12344795/count-the-number-of-occurrences-of-a-string-in-a-varchar-field