Searching my database

I have a database of rockgroups and I want ppl to be able to search it and not having to spell the intire name....

ex)
search phrase: maid
result: Iron Maiden

Any ideas anyone.... I feel totally lost.

If you're not using a RDBMS like MySQL then use your PHP ereg......

from the form

i.e.
eregi("::alpha::{4,}", $query);

... regular expressions are life savers I know for a fact from my professional experiences with PERL. Happy Coding!

In SQL it would be something like this:

SELECT * FROM table WHERE something LIKE '%maid%'

For a full PHP action:

$db = mysql_pconnect("localhost", "username", "password");
mysql_select_db("dbname",$db);

mysql_query("SELECT * FROM table WHERE something LIKE '%$searchItem%'",$db);

Hope that helps.

That last one helped me alot. thanks =)

You might want to specify what DBMS in the future!