Just to clarify, my problem is that I do not want MySQL to use "disk-based"
temp file. Everytime I try to ORDER a result set that contains a TEXT type
field, MySQL will use disk based temp file.
What can I do to:
1. SELECT a TEXT type field
2. ORDER by an INT column
3. not use a disk based te
I have a query:
SELECT feature_type.title, feature.title
FROM feature_build
LEFT JOIN feature ON feature_build.feature_id = feature.id
LEFT JOIN feature_type ON feature_build.feature_type_id = feature_type.id
WHERE feature_build.product_id = '112479'
AND feature_type.full_ordinal != 0
O