| 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' | SolidEther | 9 Dec |
| • Re: different results from '=' vs. 'LIKE' | Daevid Vincent | 9 Dec |
| • Re: different results from '=' vs. 'LIKE' | SolidEther | 9 Dec |
| • Re: different results from '=' vs. 'LIKE' | Daevid Vincent | 9 Dec |
| • Re: different results from '=' vs. 'LIKE' | SolidEther | 9 Dec |
| • Call for Articles for Winter Issue of MySQL Magazine | bmurphy | 9 Dec |
