Re: Searching for any number in a mysql query

Hi, try something like this: "select [fields] from [table(s)] where [fieldtosearch] regexp "^([1-9]{1}|10)"; ~James <webmaster@tececo.com> wrote in message news:003901c200b2$27ccff40$0100a8c0@JohnH... 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