By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
| code | value |
|---|---|
| blah blah six letter CML Code B12345 who what | B12345 |
| thing thing but not CML Code NM1234 blat | NM1234 |
| another thing to think about is L98125 | L98125 |