Finding Missing Values - EXCEPT

Anon

I am trying to build a search that returns the matching records as well as the non-matching records.

Does anyone have a solution to doing this?

I am currently trying to do it using the NOT IN function in MySQL. I am having difficulty though because you have to build a set of values that will not be considered in your search.

Those NOT IN values are the IDs of the records that are found. I am having trouble because the number of records found will change.

The syntax for the NOT IN function is this:

Field1 NOT IN (value1, value2, value3, etc..)

Anon

I am trying to build a search that returns the matching records as well as the non-matching records.

Seems like that would mean all records, because it is either a match or not. Why not just select all records and then do an IF on each item as you iterate through your returned array.

If it is not a match, put it in an array. If it is a match, put it in a seperate array.

Anon

Sounds good, but how do I then insert all the values of the array into the SQL query?

Anon

Not sure what you mean there. You are going to search through the table, then place the results of that search into a SQL query?