By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
| path | pos1 | pos2 | (No column name) |
|---|---|---|---|
| Q:\12345\downloads\randomfilename.png | 3 | 9 | 12345 |
| Q:\123_4566\downloads\randomfilename.pdf | 3 | 12 | 123_4566 |
| Q:\CCCMUD\downloads\randomfilename.mp4 | 3 | 10 | CCCMUD |
| Q: | null | null | null |
| Q:\ | 3 | null | null |
| Q:\file.bmp | 3 | null | null |
| Q:\test\file.bmp | 3 | 8 | test |