Php Mysql : Code for Multiple Field Search

[isomillennium]

What would be the php mysql code to search more than 1 field in a table ?

Im trying to search for a given partial phone number in all three fields home mobile and work ..

im trying to use

$query = "SELECT `first`, `last`, `home_phone` , `work_phone` , `mobile_phone` FROM `profiles` WHERE LIKE '%516353%'

but this returns everything thats in the table

Any help would be appreciated

[nav33n]

$query = "select * from table where home_phone like '%516%' OR work_phone like '%516%' OR mobile_phone like '%516%'";

[isomillennium]

$query = "select * from table where home_phone like '%516%' OR work_phone like '%516%' OR mobile_phone like '%516%'";

thatnk it worked fine i just had to change OR TO ||

[nav33n]

:) It should work with OR.. But anyway, cheers!