SELECT ahl_school.id,ahl_school.sn,ahl_schooljobs.* FROM
ahl_school INNER JOIN ahl_schooljobs ON ahl_school.id = ahl_schooljobs.sid where ahl_schooljobs.showcommon='1' and ahl_schooljobs.province like '%Xinjiang%' or ahl_schooljobs.province like '%Qinghai%' or ahl_schooljobs.province like '%Gansu%' or ahl_schooljobs.province like '%Mongolia%' or ahl_schooljobs.province like '%Ningxia%' and salary='3000-4000(RMB)' and jobtype='Full time' and teachto='Primary school' order by updatetime desc后面的条件语句都不会执行。无解。。
ahl_school INNER JOIN ahl_schooljobs ON ahl_school.id = ahl_schooljobs.sid where ahl_schooljobs.showcommon='1' and ahl_schooljobs.province like '%Xinjiang%' or ahl_schooljobs.province like '%Qinghai%' or ahl_schooljobs.province like '%Gansu%' or ahl_schooljobs.province like '%Mongolia%' or ahl_schooljobs.province like '%Ningxia%' and salary='3000-4000(RMB)' and jobtype='Full time' and teachto='Primary school' order by updatetime desc后面的条件语句都不会执行。无解。。
解决方案 »
- mysql的问题 怎么合并这2句呢
- 哪位提供下MYSQL的教学视频,资料啊
- 多个字段建立索引
- 怎样设置 mysql的relay-log 文件
- 这个存储过程哪错了 怎么通不过
- struts下做文件上传时碰到数据类型转换问题,高手请进帮忙
- 如何获得字符(varchar)字段的最大值,字段里面的值为整形的字符串
- [求助]MySql更新数据的问题。
- 这样的SQL语句怎样转化成能在mysql下运行的
- 我起先用solaris自带的apache安装了web,我现在想加入php+mysql支持,我该怎么做?
- 大家帮忙看一条sql语句,只能select一部分
- mysql sql语句整数做过除法之后的排序出了问题?
[/align]
FROM ahl_school INNER JOIN ahl_schooljobs ON ahl_school.id = ahl_schooljobs.sid
where ahl_schooljobs.showcommon='1'
and (ahl_schooljobs.province like '%Xinjiang%'
or ahl_schooljobs.province like '%Qinghai%'
or ahl_schooljobs.province like '%Gansu%'
or ahl_schooljobs.province like '%Mongolia%'
or ahl_schooljobs.province like '%Ningxia%')
and salary='3000-4000(RMB)'
and jobtype='Full time'
and teachto='Primary school'
order by updatetime desc估计你想要这个效果,注意括号的位置,我加了一对()[align=center]==== 思想重于技巧 ====
[/align]