how to use force index when construct session

[imqishi]

I want use session construct a query which has force index(specify_index)
is there a way to do this? if Session.statement is accessable, I can directly set session.Statement.JoinStr

[lunny]

Could you give an example of the SQL or table structure?

[imqishi]

sorry for some confidential reason I cannot give table structure, but the SQL like this:

select * from myTable force index(specific_index) where a = 1 and b = 2 and c in (3,4,5)

if table is too large, mysql may not use correct index so sometimes force index is necessary