How do I change the query below to search in two fields instead of just one? For example, I want the query to search two fields: job_id and jobtype - instead of just job_id.
$query = "SELECT lastname, firstname, state, zip, jobtype, otherjobtype, nightavail, weekendavail, ptft, resume FROM data WHERE job_id LIKE '%" . $trimmed . "%' ORDER BY lastname ";