[Resolved] Putting all states into array?

[kilbey1]

I'm not sure if the title is what I want to do, so I'll try to explain.

I have a resume form that picks consultants by state (such as an html guru in California, or an SAP expert in Alabama). But what if I want to pick from ANY state?

When I put in criteria, the SQL comes back like so...

SELECT SQL_CALC_FOUND_ROWS * FROM resume INNER JOIN candidate WHERE resume.Section_ID = '1' AND MATCH (resume.Section_Value) AGAINST ('+html' IN BOOLEAN MODE) AND candidate.Candidate_ID = resume.Candidate_ID AND candidate.Location IN ('CA', 'California') LIMIT 0 , 10

(note the candidate.Location IN('CA','California').

Now, when I want to pull back ANY state, I need to pull it back from anywhere. If I leave the candidate.Location part off, will it automatically search anywhere? Or do I need to go through my states database and put it into an array so that the IN portion is filled in with all states?

[lazzerous]

leaving out the specifier for location will search all locations.