Gossamer Forum
(Advanced Search)
for
Home : General : Perl Programming :

MySQL problem

Oct 16, 2003, 7:49 PM
NamedRisk
User (51 posts)
NamedRisk's avatar
Oct 16, 2003, 7:49 PM
Post #1 of 4
Views: 4178
Shortcut
Quote Reply
MySQL problem
Hi, i want to know if exist a simple way to select only numbers 0-9 with a simple mysql sentece using perl ( not php ) to get all result with begin with numbers 0...9 ...



Thanks...

perl is given me a Pirate

sorry my bad english
Oct 16, 2003, 9:54 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
Oct 16, 2003, 9:54 PM
Post #2 of 4
Views: 4058
Shortcut
Quote Reply
Re: [NamedRisk] MySQL problem In reply to
BETWEEN or > < operators in the WHERE clause...

EXAMPLE:

(ColumnName >= 0)
AND
(ColumnName <= 9)

- OR -

(ColumnName BETWEEN 0 AND 9)
========================================
Buh Bye!

Cheers,
Me
Oct 16, 2003, 10:05 PM
NamedRisk
User (51 posts)
NamedRisk's avatar
Oct 16, 2003, 10:05 PM
Post #3 of 4
Views: 4061
Shortcut
Quote Reply
Re: [Stealth] MySQL problem In reply to
Thanks a lot man...

=D i'm too newbee =D LoL
Oct 27, 2003, 9:42 AM
NamedRisk
User (51 posts)
NamedRisk's avatar
Oct 27, 2003, 9:42 AM
Post #4 of 4
Views: 4023
Shortcut
Quote Reply
Re: [NamedRisk] MySQL problem In reply to
This way that you propose to use... only work for number... and i found another tha work good for all...

collumname REGEXP '^[0-9]'



^ to match only the begin... 0123 take the 0.

and [0-9] to search for numbers begin 0 since 9...



sorry my bad english.