Hi,
In one of my tables I have a column which contains a combination of a string
(characters only), a space and a 1 or 2 letter combination. The string has no
fixed lenght. Like:
abcd ef
bcdefgh i
etc
Now I want to remove the 1 or 2 letter combination from this column into
another column. I can select the rows with
WHERE colX REGEXP ". .{1,2}$"
This wil return the first two rows only. But I cannot figure out how to get
the query to return the matching result (being ef and i).
Any help appreciated
Mike