its cool i got the 4 backslashes thing worked out thanks very much for the pointer :)
--- "even if my world is weird its my world" > -----Original Message----- > From: Keith C. Ivey [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 13, 2003 16:11 > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: suspected bug... > > > On 13 Mar 2003, at 15:30, lauren wrote: > > > the actual horror story query is: > > > > update link set path=insert(path,1,13,'\\test\\test21\\') where > > person_id = 8 and path like '\\test\\test2\\%' > > You still haven't told us how you're sending this query to MySQL, and > my advice remains the same. If at all possible, avoid the problem by > using forward slashes rather than backslashes in your paths. If > that's not possible, carefully work through how many levels of > escaping you need to get MySQL to see the final SQL statement as you > want it. Note that for the LIKE part of your query you're going to > need four backslashes to match a single backslash, which means you > likely will be typing eight backslashes at that point in your PHP (or > whatever) code. See the documentation: > > | Note: Because MySQL uses the C escape syntax in strings (for > | example, `\n'), you must double any `\' that you use in your > | LIKE strings. For example, to search for `\n', specify it as > | `\\n'. To search for `\', specify it as `\\\\' (the backslashes > | are stripped once by the parser and another time when the > | pattern match is done, leaving a single backslash to be > | matched). > http://www.mysql.com/doc/en/String_comparison_functions.html -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 --------------------------------------------------------------------- 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