This works:
mysql> select trim('foo' FROM 'foobaar');
+----------------------------+
| trim('foo' FROM 'foobaar') |
+----------------------------+
| baar |
+----------------------------+
1 row in set (0.00 sec)
This does not work: !
mysql> select trim('foo' FROM 'foo');
+------------------------+
| trim('foo' FROM 'foo') |
+------------------------+
| foo |
+------------------------+
1 row in set (0.00 sec)
I was expecting a null string from this one.. But nope ??
Why ? Is it a bug?
Using Linux (Redhat 6.2) and MySQL-3.23.24-1
/ Paul
---------------------------------------------------------------------
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
