Searching for any number in a mysql query
| From: | webmaster at tececo dot com | Date: | Tue, 21 May 2002 10:27:48 +0000 |
| Subject: | Searching for any number in a mysql query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-98573@lists.php.net to get a copy of this message | ||
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