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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
