[Solved] Pull specific numbers from a column that has numbers and words

Question

I ended up subquerying with this in the SELECT — cast(substring(column FROM ‘[0-9]+’) as int) and this in the WHERE column ~ ‘^\d+$’ in the FROM as its own table. Pulling just the integers i needed from that with IN (1,2,3)

Accepted Answer

I ended up subquerying with this in the SELECT — cast(substring(column FROM ‘[0-9]+’) as int) and this in the WHERE column ~ ‘^\d+$’ in the FROM as its own table. Pulling just the integers i needed from that with IN (1,2,3)