RE: [PHP] Searching for any number in a mysql query
| From: | John Holmes | Date: | Tue, 21 May 2002 12:20:56 +0000 |
| Subject: | RE: [PHP] Searching for any number in a mysql query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-98586@lists.php.net to get a copy of this message | ||
Use regular expressions or LEFT. This might work
SELECT code FROM links WHERE LEFT($text,1) IN (1,2,3,4,5,6,7,8,9,0);
Check the manual for regular expression examples. They will probably
work better.
---John Holmes.
-----Original Message-----
From: webmaster@tececo.com [mailto:webmaster@tececo.com]
Sent: Tuesday, May 21, 2002 6:28 AM
To: php-general@lists.php.net
Subject: [PHP] Searching for any number in a mysql query
This isn't a one hundred percent PHP Q but here I go.
If I have the following query:
$query = "SELECT code FROM links WHERE ".$text." like '".$l."%'
ORDER BY
sort_text";
and define the letter a letter i.e x.
it works fine.
I am not sure what to do if I want to say get something that starts with
(from one to ten).
I want to say all the numbers at once, not one at a time.
Any help appreciated,
JJ Harrison
webmaster@tececo.com
www.tececo.com