Count number of specific character in string (MySQL)
Naar navigatie springen
Naar zoeken springen
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;