List:General Discussion« Previous MessageNext Message »
From:SolidEther Date:December 8 2008 11:42pm
Subject:different results from '=' vs. 'LIKE'
View as plain text  
Hi,

I'm trying to compare strings on a varchar field.

The code: 'select * from Image where `0020,0032`="-131.178600\ 
\107.113725\\200.064000";' returns the correct result set.

However, the code: 'select * from Image where `0020,0032` LIKE  
"%-131.178600\\107.113725\\200.064%";' returns an empty set, and so  
does 'select * from Image where `0020,0032` LIKE "-131\.178600\\107\. 
113725\\200\.064000";'

I can't really figure out why, can anyone explain?

Thx,
Michael
Thread
different results from '=' vs. 'LIKE'SolidEther9 Dec
  • Re: different results from '=' vs. 'LIKE'Daevid Vincent9 Dec
    • Re: different results from '=' vs. 'LIKE'SolidEther9 Dec
  • Re: different results from '=' vs. 'LIKE'Daevid Vincent9 Dec
    • Re: different results from '=' vs. 'LIKE'SolidEther9 Dec
      • Call for Articles for Winter Issue of MySQL Magazinebmurphy9 Dec