Hi MySQL Fans ;-), I have problems understanding why the below two commands would return the same result.
1) mysql> select * from sensei where link like '/var/www/html/xoops/2003\'s sum'; +---------------+--------------------------------+-------------+---------------+ | instructor_id | llink | character | e_mail | +---------------+--------------------------------+-------------+---------------+ | KDC009 | /var/www/html/xoops/2003's sum | Character's | [EMAIL PROTECTED] | +---------------+--------------------------------+-------------+---------------+ 1 row in set (0.00 sec) 2) mysql> select * from sensei where last_name like '/var/www/html/xoops/2003\\\'s sum'; +---------------+--------------------------------+-------------+---------------+ | instructor_id | link | charcter | e_mail | +---------------+--------------------------------+-------------+---------------+ | KDC009 | /var/www/html/xoops/2003's sum | Character's | [EMAIL PROTECTED] | +---------------+--------------------------------+-------------+---------------+ --- Note the three backslashes and the single backsplash (after the 2003) I understood the first sample looks for ...2003's.... and the second one for ...2003\'s..... or am I wrong ? Best regards -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
