I created a FULLTEXT Index for columns: City, Group and Text
called city_group_text_comparator
How do I do a simple query to look up a string on all 3?
I tried this:
$result = mysql_query("SELECT * FROM Posts WHERE MATCH (City, `Group`, Text) AGAINST ('$search') LIMIT $limit_posts OFFSET $first_post");
How does it order the results?
Thanks