Hi,
>> 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)
If all you want to do is remove any occurance of 'foo' in a string or column
value then I'd recommend you look at the REPLACE() function in the manual.
Regards,
------------------------------------------------
Basil Hussain ([EMAIL PROTECTED])
---------------------------------------------------------------------
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
