NOT LIKE error
am 24.06.2003 04:31:02 von Rohan Hawthorne------_=_NextPart_001_01C339F8.A7D8D7F6
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Not sure if this is a bug, but couldn't find any documentation to
explain it - I'm guessing it's standard
SQL for the version I'm on ? (4.0.13)
=20
The 'problem' is that it doesn't return the NULL row with the NOT LIKE
statement.
=20
=20
mysql> describe test_like;
+---------+---------+------+-----+---------+---------------- +
| Field | Type | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+---------------- +
| test_id | int(11) | | PRI | NULL | auto_increment |
| name | text | YES | | NULL | |
+---------+---------+------+-----+---------+---------------- +
2 rows in set (0.00 sec)
=20
mysql> select * from test_like;
+---------+-------+
| test_id | name |
+---------+-------+
| 1 | one |
| 2 | two |
| 3 | NULL |
| 4 | three |
+---------+-------+
4 rows in set (0.00 sec)
=20
mysql> select * from test_like where name not like '%o%';
+---------+-------+
| test_id | name |
+---------+-------+
| 4 | three |
+---------+-------+
1 row in set (0.00 sec)
=20
=20
________________________________
=20
ICT Helpdesk: 8939 7116
=20
________________________________
=20
ICT Helpdesk: 8939 7116
=20
------_=_NextPart_001_01C339F8.A7D8D7F6--