Searching multiple numbers

[Radon3k]

It's fairly easy to search for something in PHP and MySQL:

$result = mysql_query("SELECT * FROM users WHERE firstname LIKE '%John%'");

What I want to do is do multiple searches for numbers in the same query. Numbers 0-9, such as this:

$result = mysql_query("SELECT * FROM numbers WHERE number LIKE '1%', '2%'");
// That pattern would continue until you reach 0

However I'm not sure how to do that without doing multiple queries. I've tried several different ways and none of them seem to work. Anybody have any suggestions? Thanks. 🙂

[Weedpacket]

You mean something like "WHERE number LIKE '1%' OR number LIKE '2%' ... "?

[Radon3k]

Ah, that's what I was doing wrong. I was leaving out the extra 'number' bit. I knew I was missing something. Thanks! 🙂