SQL Query

Hi Tim,

In this case you might be better using an IN statement, something like this should work:

SELECT s.num FROM `<?php echo $TABLE_PREFIX . nlb_subscriber_table() ?>` s
 WHERE s.`<?php echo nlb_subscriber_confirmedField() ?>` = 1
   AND `membership_type` IN('5','3')


So the IN function checks if a field contains the comma separated values in the function.

Cheers

Greg

Hi Tim,

Unfortunately we don't have a resource for common MySQL functions. I'm not sure it would be possible as so many queries are completely unique, and they become complicated once you've gone outside of the basic where statement.

Cheers

Greg