Select Statement

[fnbcprog]

How do you accomplish a search based upon two columns from the same table?

I have a table that is setup in this fashion:

id_number | lastname | name_mi

100000001 Doe John

I want a user to be able to type in : Doe, John
and get this record in return.

How do I do a select statement on these two columns using the LIKE % command?

[tomhath]

select * from theTable where col1 like 'xxx%' and col2 like 'yyy%'

This is very fundamental, a little time invested in SQL basics would be well spent.