List:General Discussion« Previous MessageNext Message »
From:Mike Blezien Date:June 8 2006 1:46pm
Subject:Re: correct syntax
View as plain text  
Gerald,
----- 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:
>> 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
Thread
correct syntaxMike Blezien8 Jun
  • Re: correct syntaxGerald L. Clark8 Jun
  • Re: correct syntaxMike Blezien8 Jun