RE: Select a range from 0-9 or A-z
-Original Message- From: Ung, Seng Sent: Tuesday, February 06, 2001 9:03 AM To: [EMAIL PROTECTED] Subject: Select a range from 0-9 or A-z hi: Here is my SQL statement to select a range of number from 0-9 Is there a short cut to this? id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%' thank you seng - 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
Re: Select a range from 0-9 or A-z
"Ung, Seng" wrote: hi: Here is my SQL statement to select a range of number from 0-9 Is there a short cut to this? id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%' see REGEXP in the manual you want id regexp '^[0-9]' - 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
RE: Select a range from 0-9 or A-z
Try: select whatever from whatever where field like '[0-9]%' http://www.mysql.com/doc/P/a/Pattern_matching.html -Original Message- From: Ung, Seng [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 9:03 AM To: [EMAIL PROTECTED] Subject: Select a range from 0-9 or A-z hi: Here is my SQL statement to select a range of number from 0-9 Is there a short cut to this? id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%' thank you seng - 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 - 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
RE: Select a range from 0-9 or A-z
Check out REGEXP in the manual. -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Ung, Seng [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 11:03 To: [EMAIL PROTECTED] Subject: Select a range from 0-9 or A-z hi: Here is my SQL statement to select a range of number from 0-9 Is there a short cut to this? id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%' thank you seng - 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 - 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