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