Re: different results from '=' vs. 'LIKE'

2008-12-08 Thread SolidEther
On Dec 9, 2008, at 2:27 PM, Daevid Vincent wrote: Also, I realize you're trying to 'encode' some sort of X\Y\Z coordinates in that column, so perhaps a different delimiter such as the pipe "|" character or "," would be more appropriate than a \ which has special meanings? That's actually how

Re: different results from '=' vs. 'LIKE'

2008-12-08 Thread SolidEther
On Dec 9, 2008, at 2:03 PM, Daevid Vincent wrote: Do you seriously have a column named "0020,0032" ?!!? And don't even get me started on the actual name of these images (column data). Jepp, and there are a hell of a lot of more weird number like that. That's an attribute tag from DICOM ima

Re: different results from '=' vs. 'LIKE'

2008-12-08 Thread Daevid Vincent
Also, I realize you're trying to 'encode' some sort of X\Y\Z coordinates in that column, so perhaps a different delimiter such as the pipe "|" character or "," would be more appropriate than a \ which has special meanings? Or possibly just split them out into separate X, Y, Z columns rather than c

Re: different results from '=' vs. 'LIKE'

2008-12-08 Thread Daevid Vincent
Do you seriously have a column named "0020,0032" ?!!? And don't even get me started on the actual name of these images (column data). Wow. That makes my head hurt. I think mySQL is just punishing you for both of those offenses. *hee hee* ;-p But if I were to venture a guess, and RTFM... http:/