Am trying to search my sphinx index instance but can't seem to get it working with my current logic. Basically, am using Query Builder for SphinxQL instead of the offical API but works pretty well until I tried comparing columns against each without any success.
Example 1: In MySQL
SELECT ID, NAME, NICKNAME WHERE NAME=NICKNAME;
Example 2: Query Builder for SphinxQL
$instance->select(...)->from('theIndex')->where('NAME', '=', 'NICKNAME');
The first example works well in mysql but the second one is using PHP to access SphinxQL and thus doesn't care that the value entered in the value field is actually a column. It never matches at all.
Is what am trying to achieve here even possible at all in sphinx? I have spent way too much too time searching but can't find a viable solution.
Any help will be greatly appreciated.
