Gerald,
- Original Message -
From: "Gerald L. Clark" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Thursday, June 08, 2006 8:40 AM
Subject: Re: correct syntax
Mike Blezien wrote:
Hello,
we need to query
Mike Blezien wrote:
Hello,
we need to query one of database tables that sore usernames, and many of
them have spaces in them that need to be removed. what would be the
correct function to identify each username column value that has a
space(s) in them?
TIA,
Mike(mickalo)Blezien
How abou
select word, count(word) as total
from search_words
where word is not null
group by word
order by total desc
limit 20
-Original Message-
From: Graham Nichols [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 1:36 PM
To: [EMAIL PROTECTED]
Subject: Correct syntax?
Thanks for help
"select word, count(word) as total from search_words where word IS
NOT NULL group by word order by total desc limit 20"
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]
On Thu, 19 Apr 2001, Graham Nichols wrote:
> Thanks for help from this group I'm using
>
> "sel
