trimming or just getting only numbers from column
| From: | Siim Einfeldt aka Itpunk | Date: | Tue, 28 Nov 2000 18:18:22 +0000 |
| Subject: | trimming or just getting only numbers from column | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-27649@lists.php.net to get a copy of this message | ||
Hi folks
I need to trim the value that I get from mysql. Eg.
SELECT *,trim(substring(pikkus,1,3)) as pik FROM viewall...but this one
doesn`t trim it. How could I do it the way it would work as well?
Another way that migth help me, is just to get only numberic values out of
substring(pikkus,1,3) and then even the spaces should not be
included. How?
I`ll be waiting for your ideas.
Thanks
Siim Einfeldt