Hello,
I have a problem concerning a SQL-Statement.
In the table S_Objekt I have a field S_Kapitel
(varchar (15) binary) that contains chapternumbers
like 2.2., 2.2.1., 1.1., 1.2.3. ...
The Query is to give me all chapternumbers of a
certain hierarchy. My Idea was to ask for the number
of Points (".") :
Two Points would give back "2.2." and "1.1."
Three Points would give back "2.2.1." and "1.1.3." etc.I tried to use a REGEXP, but didnt succeed. Can you help? Gru� aus Essen Sven Sch�fermeier _______________________________________________________ Klickmeister GmbH - Schuermannstrasse 39 - 45136 Essen fon +49 201 26 97 387 fax +49 201 26 97 106 mobil +49 160 824 0 892 [EMAIL PROTECTED] http://www.klickmeister.de --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
