Two questions. Which is faster? select * from table1 where (col1 like term) and (col2 like term).
or is this faster:
select col1, col2 from table1 where (col1 like term) and (col 2 like term).
My queries are dynamic and therefore can get quite large quickly depending on the user. Would it better (ie faster) if I break the queries up into bite size pieces and maybe combine them with a bit of PHP later, or just leave them as is?