Fast LIKE search

[andrew browne]

A simple query e.g.
"
SELECT *
FROM `table`
WHERE name LIKE "%uxyz%"
LIMIT 0 , 30
"

takes 0.3238 seconds on my dual core 2GRam

That's SLOW. Any way of making it faster?