Match two mysql cols on alpha chars (ignoring numbers in same field)
- by Steve
I was wondering if you know of a way I could filter a mysql query to only show the ‘alpha’ characters from a specific field
So something like
SELECT col1, col2, **alpha_chars_only(col3)** FROM table
I am not looking to update only select.
I have been looking at some regex but without much luck most of what turned up was searching for fields that only contain ‘alpha’ chars.
In a much watered down context...
I have col1 which contains abc and col two contains abc123 and I want to match them on alpha chars only. There can be any number of letters or numbers.
Any help very much wel come