fenway

TLDR -- simply your scenario and clarify your questions.

SELECT tp.tutor_id FROM tutor_profile AS tp CROSS JOIN tutor_overall_level_subject AS tols1 (tols1.tutor_id = tp.tutor_id) CROSS JOIN tutor_overall_level_subject AS tols2 (tols2.tutor_id = tp.tutor_id) WHERE tols1.subject_level_id = 1 AND tols2.subject_level_id = 2

No need to cram into one table.

Post your actual raw SQL query

Huh?

Cron job?

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=325124.0

<=> is null-safe.

Better to JOIN once per answer you're looking for.

Besides, you can't be certain you even want every word capitalize.

I don't understand your question -- the only thing LOW_PRIORITY does is change read/write lock acquisition.

Then you have a php syntax issue.

Same question applies...

Why not use EXISTS?

Again, not enough information, sorry.

Even 2 million isn't too many.

Should be trivial to split yourself.

You need to specify a table.... I don't follow.

Use a cron job.

You can't ever get 0 rows from that query.

Show us your tables.

Also, from now on, please continue your previous threads.

Because then you'll get them as a collection.

Huh?

Failing how? Echo the actual statement.