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 in my code, will it
automatically search anywhere regardless of state location? 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?
If so... what's the proper structure to list all states in this statement?
Thanks,
Eve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
