Count number of specific character in string (MySQL)
Naar navigatie springen
Naar zoeken springen
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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;