I have MySQL database of places, and I want to use the MATCH (...) AGAINST (...) function to find places with two-part names, such as New York. This is a problem because the match against syntax will recognize the second part of the name as an 'OR' condition.
SELECT * FROM places WHERE MATCH (...) AGAINST ('New York')
Will match against columns containing the word "New" or the word "York".
How can I specify the place as one string to match against, or is there a way to escape spaces in the query?
If there is no solution, then I accept workarounds to the problem if I only get results from my database that contain the two-part name.
EDIT: I'm using this for a program where a user types and I query my database for suggestions to predict what the user could be typing, so I need to match against a string that is probably incomplete.