By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
| address | length | last_space | next | fragment | chars |
|---|---|---|---|---|---|
| 216 Apartment123 AreaArea SampleWord1 Word2 MiddleTown Upper1Location Another5 NewYork | 86 | 26 | 27 | 216 Apartment123 AreaArea | 25 |
| 216 Apartment123 AreaArea SampleWord1 Word2 MiddleTown Upper1Location Another5 NewYork | 86 | 29 | 56 | SampleWord1 Word2 MiddleTown | 28 |
| 216 Apartment123 AreaArea SampleWord1 Word2 MiddleTown Upper1Location Another5 NewYork | 86 | 24 | 80 | Upper1Location Another5 | 23 |
| 216 Apartment123 AreaArea SampleWord1 Word2 MiddleTown Upper1Location Another5 NewYork | 86 | 31 | 111 | NewYork | 7 |
| 216 Apartment123 AreaArea SampleWord1 Word2 MiddleTownxx Upper1LocationUpper1LocationUpper1Location Another5 NewYork | 116 | 26 | 27 | 216 Apartment123 AreaArea | 25 |
| 216 Apartment123 AreaArea SampleWord1 Word2 MiddleTownxx Upper1LocationUpper1LocationUpper1Location Another5 NewYork | 116 | 31 | 58 | SampleWord1 Word2 MiddleTownxx | 30 |
| 216 Apartment123 AreaArea SampleWord1 Word2 MiddleTownxx Upper1LocationUpper1LocationUpper1Location Another5 NewYork | 116 | null | 88 | Upper1LocationUpper1LocationUp | 30 |
| 216 Apartment123 AreaArea SampleWord1 Word2 MiddleTownxx Upper1LocationUpper1LocationUpper1Location Another5 NewYork | 116 | 31 | 119 | per1Location Another5 NewYork | 29 |
| 216 Apartment123 AreaArea SampleWord1 Word2 MiddleTownxx Upper1LocationUpper1LocationUpper1Location Another5 NewYork x | 118 | 26 | 27 | 216 Apartment123 AreaArea | 25 |
| 216 Apartment123 AreaArea SampleWord1 Word2 MiddleTownxx Upper1LocationUpper1LocationUpper1Location Another5 NewYork x | 118 | 31 | 58 | SampleWord1 Word2 MiddleTownxx | 30 |
| 216 Apartment123 AreaArea SampleWord1 Word2 MiddleTownxx Upper1LocationUpper1LocationUpper1Location Another5 NewYork x | 118 | null | 88 | Upper1LocationUpper1LocationUp | 30 |
| 216 Apartment123 AreaArea SampleWord1 Word2 MiddleTownxx Upper1LocationUpper1LocationUpper1Location Another5 NewYork x | 118 | 30 | 118 | per1Location Another5 NewYork | 29 |
| 216 Apartment123 AreaArea SampleWord1 Word2 MiddleTownxx Upper1LocationUpper1LocationUpper1Location Another5 NewYork x | 118 | 31 | 149 | x | 1 |