search feature

Hello, I am currently working on a search feature for a client.

They want to be able to enter in a keyword and it is suppose to search an entire table to find matches.

The table has over 8 fields and I was wondering if there is a quick way to do this.

Currently my only though is to have a really long where clause with a bunch of ORs in it.

Any insight appreciated.

Originally posted by doobster

Currently my only though is to have a really long where clause with a bunch of ORs in it.

I'm not sure what else you're thinking you could do, but doing a bunch of ORs is pretty much how it would have to be done.

Yeah I figured as much, but I was hoping there was some magic feature that would help me :p

"SELECT field10,field20 FROM table WHERE MATCH (field1, field2, field3, field4, fieldX) AGAINST ('".$yourQuery."');"

You must add a fulltext index to your table though.

Hi that works quite well.

But there seems to be an issue if it should be returning multiple records.

It works fine if it only finds 1 record, but not if there should be multiple.

Anyone aware of an issue like this?

Fulltext indexes in MySQL don't index any words of 3 letters or less unless you tweak MySQL a bit... So a search for "PHP" would find nothing.

Kinda limiting.