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 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 about
LIKE "% %"
that seems to work. Thanks :)
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]