
November 19th, 2012, 05:13 AM
|
|
Registered User
|
|
Join Date: Nov 2012
Posts: 5
Time spent in forums: 47 m 46 sec
Reputation Power: 0
|
|
|
MySQL query with CONV function
table i used to execute the query is
_Count _FFID _VLD
-------------------------
1 0 1
2 3 1
3 1 1
4 2 1
5 e 1
*********SELECT _FFID FROM CsFFPCBValid WHERE CONV(_FFID,16,10) > 12
When i executed the query given above i got the result as
_FFID
------
e
But when i executed the query below , i got different result even though these have same meaning
*************SELECT _FFID FROM CsFFPCBValid WHERE CONV(_FFID,16,10) > CONV('c',16,10)
_FFID
------
3
2
e
Why it is so?
I am using mysql5.5.27 -win 32 version and Navicat as gui
|