Re: es werden keine numerischen Werte gefunden
Kann ich nicht reproduzieren:
CREATE TABLE kunden (vortel VARCHAR(10));
INSERT INTO kunden VALUES('0043'), ('00431'), ('0044'), ('00432');
mysql> SELECT * FROM kunden WHERE vortel LIKE '%043%';
+--------+
| vortel |
+--------+
| 0043 |
| 00431 |
| 00432 |
+--------+
3 rows in set (0.00 sec)
mysql> SELECT * FROM kunden WHERE vortel='0043';
+--------+
| vortel |
+--------+
| 0043 |
+--------+
1 row in set (0.00 sec)
Subject
Views
Written By
Posted
3376
July 07, 2011 04:01PM
Re: es werden keine numerischen Werte gefunden
1127
July 09, 2011 11:16AM
1128
July 09, 2011 04:03PM
1139
July 10, 2011 02:34AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.