Hello Mike,
The short answer: use Perl, Python, Ruby, etc.
You are pressing the boundaries between a query language (SQL) and a
programming/scripting language (Perl, Python, Ruby, etc.). Scripting
languages as these already have those capabilities and can easily connect
to MySQL an many other database. That is, if you create a solution with a
scripting language you will also create a more portable solution.
Regards,
- Robert
-----
At 12:40 AM 12/11/2002 +0100, Mike Bosschaert wrote:
>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).
---------------------------------------------------------------------
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
