Suppose I had a MySQL table with the following column:
|variables| 1. | 'a' | 2. | 'a b' | 3. | 'a b c' | 4. | ... |
How can I construct a MySQL Full-Text search that doesn't ignore white space in the column entries?
For example, I would like the following query to return only row 1:
SELECT column FROM table WHERE MATCH variables AGAINST ('a')
As it is, however, this query would return rows 1–3 because all three rows contain the letter 'a'.
Your search rules are unclear, but this may be a case where a regular expression search will serve you better than a full-text query.