Good morning. I am working with a php script of a search engine that performs a query to a database mysql using MATCH AGAINST in a column with FULLTEXT INDEX the problem is for example, if in my database I have "Food Mexicana "and in the search engine I type" M "returns" Mexican Food "and what I want is for me to return only the results that have that letter in the first word, the query I'm doing it like this:
$search_query = $_POST['searchQuery'] . '*';
$sql = "SELECT cat FROM cat_table WHERE MATCH(cat) AGAINST(:search_query IN BOOLEAN MODE)";