Issue using Like in select - causes Incorrect key file error
Hi all
A tricky little error being created by my Select.
It is a very long SQL select which is created by the php code.
When the code is working it has the follow in the WHERE clause - AND (m.name like '%business%' or o.name like '%business%')
Trying to use the script but find any record (ie, replace %business% with just %) causes a MYSQL Error 126 Incorrect key file error
Why would this occur, could it be a lack of temp space for running the query??
V
Subject
Written By
Posted
Issue using Like in select - causes Incorrect key file error
May 24, 2011 06:43AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.