mysql字符串比较

select '123'B is TRUE;  1

SET @a='123';            
select '123'is TRUE;      0

select cast('222' as unsigned);   222
select cast('ddd' as unsigned);   0
select cast('2d7dd' as unsigned); 2