[Resolved] COUNT Rows Help!!!!

[chuck33]

Hi Guys,

I have a mysql table, it has several columns, one of which is location.

The field is empty(blank) for some records, and in others it has the full URL of the document.

My table is called table_records.

What I need to do is display the number of records that have the url stated.

I tried the following:

1)SELECT COUNT DISTINCT location FROM table_records HAVING LENGTH(location) > 3;

2)SELECT COUNT DISTINCT(location) FROM table_records HAVING LENGTH(location) > 3;

3)SELECT location FROM table_records WHERE location <> "";

Nothing works

Can anybody help?

Thanks
Chuck

[greg252]

what about

!=""

?

[chuck33]

Sorry, That didn't work either.

Chuck

[stolzyboy]

<?
$query = "select count(location) as location_counter from table_records where location != '';";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
echo $row['location_counter'];
?>

[chuck33]

No luck I'm afraid.

Chuck

[chuck33]

Guys,

Got it:

SELECT COUNT(*) FROM table_records where LENGTH(location) > 6;

This works.

Thanks for the replies.

Chuck

[stolzyboy]

well of course ours didn't work if the so-called blank ones have more than 6 characters in it, so they aren't blank

[chuck33]

The blank ones were empty (no values at all).

The query was given to me to test.

The '> 6' was random to see if it worked,

For info '> 0' also works.

Chuck