What is the minimum character limit for full-text search in MySQL when using PHP?

When performing a full-text search in MySQL using PHP, there is a minimum character limit imposed by default. This limit is typically set to 4 characters, meaning that any search term with fewer than 4 characters will not return any results. To solve this issue, you can adjust the minimum character limit for full-text search in MySQL by modifying the ft_min_word_len setting in the MySQL configuration file. 

// Connect to MySQL database
$mysqli = new mysqli("localhost", "username", "password", "database");

// Set the minimum character limit for full-text search to 3 characters
$mysqli->query("SET GLOBAL ft_min_word_len = 3");

// Perform full-text search query
$searchTerm = "term";
$query = "SELECT * FROM table WHERE MATCH(column) AGAINST ('$searchTerm' IN BOOLEAN MODE)";
$result = $mysqli->query($query);

// Fetch and display results
while ($row = $result->fetch_assoc()) {
    echo $row['column_name'] . "<br>";
}

// Close database connection
$mysqli->close();

Keywords

MySQL full-text search PHP minimum character limit text search

Related Questions