two criteria in a select query

[kappaluppa]

I need to use two fields in a select query. I need to be able to return rows when either has a certain value. Is this how I do it? I'm looking for '$senator_search' in author_name and/or in subject

thanks...
K

---

$Query = "SELECT *, DATE_FORMAT(date, '%m-%d-%Y') AS date_format FROM $TableName where author_name LIKE '%$senator_search%' or where subject LIKE '$senator_search' ORDER BY date DESC";

[diego25]

So use the OR operator:

WHERE field1 = 'this' or field2 = 'that'

Diego