search a mysql database

[pkghost]

hi, im developing a php/mysql web app and i was wondering what the best way to search multiple columns of a table for a particular keyword is. im still pretty new to the whole php/mysql scene, so go easy. if this is a super complex task and someone is willing to give me one, i would love a crash course or at least a hand pointing me in the right direciton. thanks

[s_shrum]

I had to write my own.

Look up "Fulltext search" for info on searching.

I just broke down and created a small function set for my content script...you pass it field names and keywords, it spits out a where clause that you can use in you SQL call.

http://www.shrum.net/code/?search=where

Unless someone else can point you to an easier solution, that's my 2 cents.