Best way to code a search engine (across my database)?

[eluser]Bramme[/eluser]
I've never done that before, I'd have to look through the mysql documentation for the wildcard...

I'd do it for you, but the page is a little too long to my liking :p
http://dev.mysql.com/doc/refman/5.0/en/s...tions.html


edit: okay, wanted to know anyhow:
http://www.htmlite.com/mysql011.php

So you should replace all your special characters with an underscore and then query the db.

SELECT * FROM 'table' WHERE 'field' LIKE '%foo_ar%'