MySQL Forums
Forum List  »  Newbie

Issue using Like in select - causes Incorrect key file error
Posted by: Vaughnn Brooks
Date: May 24, 2011 06:43AM

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

Options: ReplyQuote


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.