>Description: when doing a select replace(fieldname, 'lookforstring', 'replacestring'), the replace never occurs. It works fine if searching on a static string. The behaviour is correct on my Red Hat machine. >How-To-Repeat: - easy to repeat (bug was in 3.22.23 as well) - just try a replace in any table (myisam or just isam) - seems to be os-specific >Fix: >Submitter-Id: <submitter ID> >Originator: Julian Wood "[EMAIL PROTECTED]" >Organization: University of Calgary >MySQL support: none >Synopsis: select replace not working with fields on OS X Server >Severity: non-critical >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.36 (Official MySQL binary) >Environment: System: Rhapsody movies 5.5 Kernel Release 5.5: Fri Jul 2 13:10:26 PDT 1999; root(rcbuilder):Objects/kernel-154.14.obj~10/RELEASE_PPC Copyright (c) 1988-1995,1997-1999 Apple Computer, Inc. All Rights Reserved. Power Macintosh Some paths: /usr/bin/perl /bin/make /usr/bin/cc Compilation info: CC='gcc' CFLAGS='-O2 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O2 -fno-omit-frame-pointer' LDFLAGS='' LIBC: Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --disable-shared Perl: This is perl, version 5.005_02 built for rhapsody --------------------------------------------------------------------- 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