----- Original Message -----
From: "Gerald L. Clark" <gerald_clark@stripped>
To: "Mike Blezien" <mickalo@stripped>
Cc: "MySQL List" <mysql@stripped>
Sent: Thursday, June 08, 2006 8:40 AM
Subject: Re: correct syntax
> Mike Blezien wrote:
>> 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?
> How about
> LIKE "% %"
that seems to work. Thanks :)