'\' is an escape character... so to escape it you must : SELECT * from table where field LIKE '%\\\\mydir\\\\myfile%'
Mike ----- Original Message ----- From: "Stuart Scamman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 18, 2002 5:20 PM Subject: Like and '\\' > What is the syntax to make '\\' work with like statement ? > > This example is always empty: > > SELECT * from table where field LIKE '%\\mydir\\myfile%' > > Thanks > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.314 / Virus Database: 175 - Release Date: 1/11/2002 > > --------------------------------------------------------------------- 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