昨天晚上居然她

[永远-]

字段： a(int) b(char) c(char)
12365454544554 王小 爱好打球
问题：我要a,b字段的值才能取出c的值。其中a字段的值取后面5位就可以了，这条语句的写法？

[lsxaa]

看着标题进来的,然后发现上当了

[lsxaa]

where a mod 10000 =44554 and b='王小'

[lsxaa]

where a % 10000 =44554 and b='王小'

[tdtjjiao]

select * from table where a substring(a, 9, 14) = 44554 and b='王小'

[zjcxc]

select * from table where right(a,5) = 44554 and b='王小'

[birdsmaller]

select c from temp1 where a like '%44554' and b = '王小'
这样也能查出来

[fwbj_01]

偶也上当了,还以为是闲聊的贴.

[xhwly]

select * from table where a % 10000 =44554 and b='王小'