At 11:25 -0400 10/11/04, Eve Atley wrote:
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?
Either way would work, but clearly the first is simpler. :-)
If so... what's the proper structure to list all states in this statement?
It would just be a longer IN() list.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
