How can PHP developers efficiently exclude certain words from search queries in MySQL?

To efficiently exclude certain words from search queries in MySQL, PHP developers can use the MySQL NOT LIKE operator in conjunction with PHP's mysqli_real_escape_string function to prevent SQL injection attacks. By dynamically constructing the query to exclude specific words using the NOT LIKE operator, developers can effectively filter out unwanted results from the search. 

// Assuming $mysqli is your mysqli connection

$searchTerm = mysqli_real_escape_string($mysqli, $_GET['search']);

$excludedWords = array("word1", "word2", "word3");
$excludedConditions = array();
foreach ($excludedWords as $word) {
    $excludedConditions[] = "column_name NOT LIKE '%$word%'";
}

$query = "SELECT * FROM table_name WHERE column_name LIKE '%$searchTerm%' AND " . implode(" AND ", $excludedConditions);

$result = $mysqli->query($query);

// Process the query result as needed

Keywords

PHP MySQL search queries exclude words full-text search

Related Questions