How to optimize SQL using function 'instr' ?
select textID from Texts
where instr(textContent, :strSearch);
There is a table 'texts', and primary key on column 'textID'.
I want to get those rows which column 'textContent' contains string :strSearch. This must be inefficient, but how can I complete it more efficient?
Thanks for help in advance.