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