Ah, that makes sense.
In
theory, I think it might be possible to use a gpm template to regex a full-text column and display it as an unsorted column. In practice, I'm not quite good enough at templates or regexes to try this. And it'd be the unmodified tags, which would make it kinda messy.
I
did use a regex search & replace to populate my #fanficratings column from the longtext rather than run a 'update from column' on everything, though.
search:
(?s).*(<p><span class='label'>Rating<\/span>: <div class='metadata' id='rating'>(.*?)<\/div><p>).*
replace with: \2
(
regex101 for demonstration)