nicht angemeldet
Hi Frank!
mysql> select * from tabelle where '30423' regexp plz
In der Tabelle stehen in der Spalte PLZ zB. '3', '30', '04'.
Kann es sein, dass du nur die erste Ziffer der PLZ vergleichen möchtest?
Wie wäre es mit einem where 3% LIKE plz?
Ansonsten hilft dir vielleicht das Handbuch weiter.
MfG H☼psel
--
"It's amazing I won. I was running against peace, prosperity, and incumbency."
George W. Bush speaking to Swedish Prime Minister unaware a live television camera was still rolling, June 14, 2001
Selfcode: ie:% fl:( br:> va:) ls:& fo:) rl:? n4:& ss:| de:] js:| ch:? sh:( mo:) zu:)
"It's amazing I won. I was running against peace, prosperity, and incumbency."
George W. Bush speaking to Swedish Prime Minister unaware a live television camera was still rolling, June 14, 2001
Selfcode: ie:% fl:( br:> va:) ls:& fo:) rl:? n4:& ss:| de:] js:| ch:? sh:( mo:) zu:)