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
Hi Roger,
Thanks for the thorough explanation. I think I got it now ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 8月 14日 木曜日 20:47、Roger Baklund さんは書きました:
> * Roger Baklund
>
> > > They both look for "2003's".
>
> * Nils Valentin
>
> > Thats what I also thought at first sight, but there s
* Nils Valentin
> I have problems understanding why the below two commands would
> return the same result.
[...]
> mysql> select * from sensei where link like
> '/var/www/html/xoops/2003\'s sum';
[...]
> mysql> select * from sensei where last_name like
> '/var/www/html/xoops/2003\\\'s sum';
[..
* Roger Baklund
> > They both look for "2003's".
* Nils Valentin
> Thats what I also thought at first sight, but there seems to be
> more to it.
>
> >
> > The LIKE operator is a pattern matching operator. The operand
> > is evaluated twice: first by the parser, and then when the
> > pattern m
Hi Roger,
2003年 8月 14日 木曜日 19:33、Roger Baklund さんは書きました:
> * Nils Valentin
>
> > I have problems understanding why the below two commands would
> > return the same result.
>
> [...]
>
> > mysql> select * from sensei where link like
> > '/var/www/html/xoops/2003\'s sum';
>
> [...]
>
> > mysql> sel
