[SOLVED] Problems Searching multiple fields in single table.

[Hardwarez]

I have a table with 5 names fields in it. I want to search all 5 for a name.

 

This is what I have tried:

$query = "SELECT * FROM timesheets WHERE name1 LIKE '%$semployee%'";

Finds single names fine

 

$query = "SELECT * FROM timesheets WHERE name1 OR name2 LIKE '%$semployee%'";

Only fines one of many. Ie finds Jane Doe, but does not find Jane

 

$query = "SELECT * FROM timesheets WHERE name1 OR name2 OR name3 OR name4 OR name5 LIKE '%$semployee%'";

This one takes a long time to run and returns nothing like the name I entered.

 

How can I do the search to get LIKE names in any on of my 5 name entries in my table?

???

[rajivgonsalves]

you have to specify the match again

 

$query = "SELECT * FROM timesheets WHERE name1 LIKE '%$semployee%' OR name2 LIKE '%$semployee%'";

[fenway]

Or you could fulltext all 5 columns... but I question the duplication of columns, goes against normalization rules.

[Hardwarez]

Thank you!  Its been a while for me..