List of names starting with a digit

[zzz]

Sudden block...

I'm writing a script to retreive list of company names that start with a particular letter. Doing it like:

WHERE name LIKE '".$letter."%'

works file but how do I get the names that start with a digit?.. Completely blanked out.

[Drakla]

Look at the mysql site for RLIKE or REGEXP, they're the same thing

[zzz]

Thanks, but I'm not sure how I can use these. The manual says:

REGEXP and RLIKE use the current character set when deciding the type of a character.

Now my code looks something like that:

$list = $db->get_results("
								SELECT * FROM directory
								WHERE name LIKE '".$letter."%'
								ORDER BY name ASC"))
	{

	foreach ($list as $l)
	{
		echo $l->name."<br>";
	}
}

[Drakla]

Hang on - this isn't just as simple as somebody will type in 'K' and it'll show them all K companies, and you want them to type in a 3 and they'll get things like 3com?

Are you doing a nav bar with abcd and then with # for numbers, like you get here:
http://www.gamerevolution.com/article/index.php?type=review&platform=xbox

In that case you'd do
SELECT * FROM table WHERE name RLIKE "^{[[:digit:]]";}

You could also use the character class [0-9] instead of that digit nonsense

[jbatson]

In php you dont have to declare whether your using ints, string, char etc.... php will look at the number and it should find it without any problems.

[zzz]

Yes, exactly. The A-Z is simple, since the value is directly wired in. I can get the rest, non-alpha be under # , like in your example. I guess I have to put some logic to select an appropriate query, sommething like:

if ($letter == '#') {
   SELECT * FROM table WHERE name RLIKE "^[[:digit:]]";
} else {
   DO MY OTHER THING
}

Am I on the right track here?

[Drakla]

Yes, that's the ticket.