[Solved]Help with mysql index

[eluser]rogierb[/eluser]
Hi guys n gals,

I've got a query like

Code:

SELECT * FROM user where (lastname like 'myself%' OR firstname like 'myself%')
ORDER BY lastname,  firstname

to search for either lastname or firstname.

Somehow I don't seem to be able to get a working index for this query. I've played around with fulltext and a sh*tload of other possibilities but i can only get it working with just one 'like'. As soon as I add the second one, *poof* the index doesn't work anymore.

Anyone out there that can kick me in the right direction?

Thanx;-)