SQL SELECT Query - Help Needed

The_Chancer

I have a SQL select query which has to give back the following:

Select all records from one unit out of 21 that have an enquiry type of Enquiry or Provisional and a timestamp that is not greater than today.

I can do it in two SELECT statements like this :
$query = "SELECT FROM enquiry WHERE chasedate!>'$today' AND orighotelid='$ccslocation' AND enquiry_type='Enquiry'";
AND
$query2 = "SELECT FROM enquiry WHERE chasedate!>'$today' AND orighotelid='$ccslocation' AND enquiry_type='Provisional'";

But this is too messy and I would like only one statement.

Any takers ?

Lars_Berg

$query = "SELECT * FROM enquiry WHERE chasedate <= '$today' AND orighotelid='$ccslocation' AND enquiry_type in ('Enquiry','Provisional')";

The_Chancer

Many thanks.
I had looked about but never seen the "in" part before. Are there more docs to read on this subject ? And is there a limit to the number of options you can use with it ?

Lars_Berg

There isn't much to read.

c in (1,2) is just a shorthand for

(c = 1 or c = 2)

There are always limits on the complexity of a query but it should not have any practical implications.

The_Chancer

Ahh, many thanks.

My coding knowledge grows daily..