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
--
MySQL General Mailing List
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
Gerald,
- Original Message -
From: Gerald L. Clark [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Thursday, June 08, 2006 8:40 AM
Subject: Re: correct syntax
Mike Blezien wrote:
Hello,
we need to query one of database tables
Hi,
I have been bashing my head for a couple of hours now trying to
create an enum field which will hold a true or false (1 or 0)
value, but I always get an error when I try to create the enum
field.
What is the SQL syntax to create such a field in phpMyAdmin?
I tried to use the building
McGrotty, Charles writes:
I have been bashing my head for a couple of hours now trying to
create an enum field which will hold a true or false (1 or 0)
value, but I always get an error when I try to create the enum
field.
An ENUM can only hold strings, so you're probably missing
the quotes
Thanks for help from this group I'm using
"select word, count(word) as total from search_words group by word order by
total
desc limit 20"
to locate the top 20 words in a database of website search engine words.
The database had been altered to include an extra column, other than the
'word'
"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
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
