求给个思路，设计性问题

[华美乐章]

sprintf(SqlCall, "select customerid, nums, deptcode, telephone, familyphone, littlephone, officephone, state+1, result, id from %s where state between 0 and 2 and result = 0 and enable = 1 and callstate = 0 order by state %s limit %d", worktable, count >= 0 ? "asc" : "desc", abs(count));

执行这个SQL后，取telephone, familyphone, littlephone, officephone字段，为这4个字段的值，设置优先级（优先级为：telephone>littlephone>familyphone>officephone）
1.现在要求在数据库另建一张表set_callphone_priority 来设置他们的优先级，请问这个表怎么设计？

[yaozhiyong110]

你这个优先级是要干嘛？

[华美乐章]

问题解决了..

[lgstudyvc]

我进来看看标题起的是不是故意的

[lgstudyvc]

优先级，排个序不行

[华美乐章]

引用 2 楼 lgstudyvc 的回复:

优先级，排个序不行

怎么给排序法？数据库设计成 telephone 3 littlephone 2 familyphone 1 officephone 0 代码里面比大小？？