mysql indexing problem

[hassanab]

I create index org_name on mysql. When I execute query

explain SELECT *
FROM `logistics`
WHERE org_name LIKE '%united%';


it give me this result
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE logistics system NULL NULL NULL NULL 1

I need to use index What should I do?

[abduraooft]

explain SELECT *
FROM `logistics`
WHERE org_name LIKE '%united%'; You may need to use fulltext index, see http://devzone.zend.com/article/1304