asterisk in mysql_query()

[niche]

I'm under the impression that the asterisk in this command includes every single column for that table.If so how would I rewrite this command to only include the two relevant columns (begin and end)?i.e.: $result = mysql_query("SELECT * FROM plan WHERE DATE('2010-10-05 00:00:00') BETWEEN DATE(begin) AND DATE(end)")Is there a W3school reference for this task of other ref if w3s not avail? Is the non-asterisk approach faster?Thanks

[justsomeguy]

You just separate the column names with commas. It's typically more efficient to only select what you need instead of everything. If you want to speed up the search you can also define indexes on each column in the WHERE clause.

[niche]

This works:$result = mysql_query("SELECT * FROM plan WHERE DATE('2010-10-10 00:00:00') BETWEEN DATE(begin) AND DATE(end)");This didn't:$result = mysql_query("SELECT begin, end FROM plan WHERE DATE('2010-10-10 00:00:00') BETWEEN DATE(begin) AND DATE(end)");Or, is there a conflict between specifying columns and using WHERE?

[justsomeguy]

Not there, I don't see a reason why that wouldn't work. What do you mean it doesn't work, is there an error?

[niche]

Seems $results limited the returned array to the specified columns (I should have thought/know that) while the code I used also required additional keys to be present in the array. I added additional fields to be selected and Voila!Lessen learned. I think. Please let me know if not or if you have additional info.

[niche]

Thanks again for your help justsomeguy.