EXPLAIN SELECT DISTINCT tiger_person_resume.Email
FROM tiger_person_resume
LEFT JOIN tiger_memo_record ON tiger_memo_record.Email = tiger_person_resume.Email
LEFT JOIN tiger_person_work ON tiger_person_work.Email = tiger_person_resume.Email
LEFT JOIN tiger_person_copy ON tiger_person_copy.Email = tiger_person_resume.Email
WHERE 1
AND (
(
tiger_memo_record.memo LIKE '%销售%'
AND tiger_memo_record.memo LIKE '%总监%'
)
OR (
tiger_person_work.Work_content LIKE '%销售%'
AND tiger_person_work.Work_content LIKE '%总监%'
)
OR (
tiger_person_resume.Self_evaluate LIKE '%销售%'
AND tiger_person_resume.Self_evaluate LIKE '%总监%'
)
OR (
tiger_person_copy.copy_content LIKE '%销售%'
AND tiger_person_copy.copy_content LIKE '%总监%'
)
)这个查询我explain后结果如下:
我已经在tiger_person_resume建立了索引,为什么就只有我查询的tiger_person_resume没有使用"ref",可能索引是email了??
FROM tiger_person_resume
LEFT JOIN tiger_memo_record ON tiger_memo_record.Email = tiger_person_resume.Email
LEFT JOIN tiger_person_work ON tiger_person_work.Email = tiger_person_resume.Email
LEFT JOIN tiger_person_copy ON tiger_person_copy.Email = tiger_person_resume.Email
WHERE 1
AND (
(
tiger_memo_record.memo LIKE '%销售%'
AND tiger_memo_record.memo LIKE '%总监%'
)
OR (
tiger_person_work.Work_content LIKE '%销售%'
AND tiger_person_work.Work_content LIKE '%总监%'
)
OR (
tiger_person_resume.Self_evaluate LIKE '%销售%'
AND tiger_person_resume.Self_evaluate LIKE '%总监%'
)
OR (
tiger_person_copy.copy_content LIKE '%销售%'
AND tiger_person_copy.copy_content LIKE '%总监%'
)
)这个查询我explain后结果如下:
我已经在tiger_person_resume建立了索引,为什么就只有我查询的tiger_person_resume没有使用"ref",可能索引是email了??
解决方案 »
- 求一个简单的sql
- 关于查一个表中相同数据的SQL语句
- mysql有没有oracle那样的exception控制机制?
- mysql数据从5.0导入到4.1.7乱码问题怎么解决啊?
- PHP的mysql_query如何执行多条SQL语句
- MySQL是否支持数组类型?
- 性能优化问题
- linux上java访问mysql的问题:(1)安装了jdk和mysql后是不是就可以用jdbc了;(2)访问url和要加载的driver应该如何写?
- 表关联查询
- 关于没相应数据就插入,有数据就更新的问题
- 我想输入数据 use mysql script how to do that ? only 48 mark left!
- 【30分】问个小小滴问题
utpcb,我并没在email字段上使用模糊查询!!
FROM tiger_person_resume
LEFT JOIN tiger_memo_record ON tiger_memo_record.Email = tiger_person_resume.Email
LEFT JOIN tiger_person_work ON tiger_person_work.Email = tiger_person_resume.Email
LEFT JOIN tiger_person_copy ON tiger_person_copy.Email = tiger_person_resume.Email
WHERE 1
AND (
tiger_memo_record.memo = '销售'
OR tiger_person_work.Work_content = '销售'
OR tiger_person_resume.Self_evaluate = '销售'
OR tiger_person_copy.copy_content = '销售'
)
AND tiger_person_resume.Email = tiger_memo_record.Email 我改成以上的语句,但在key和key_len中均是null,extra还是使用Using temporary
The index will be used.
谢谢了!