Issue using Like in select - causes Incorrect key file error

[Vaughnn Brooks]

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