История изменений

SELECT
	*
FROM
	table1 t
	LEFT JOIN LATERAL (
		SELECT tw.w FROM regexp_split_to_table(t.jb_data::text, '[^A-Za-z0-9]+') AS tw(w)
	) x ON TRUE
WHERE 
	x.w::text % 'frst'
;

SELECT
	*
FROM
	table1 j
	LEFT JOIN LATERAL (
		SELECT w FROM regexp_split_to_table(j.jb_data::text, '[^A-Za-z0-9]+') AS w
	) x ON TRUE
WHERE 
	x.w::text % 'frst'
;