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
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...
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
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
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 the