What are some alternative methods, besides using ENUM columns, to sort mysql_query output based on specific words in PHP?

When sorting mysql_query output based on specific words in PHP, an alternative method is to use the ORDER BY FIELD() function in the SQL query. This function allows you to specify a custom order for the results based on a list of values. By using this method, you can achieve the desired sorting without the need for ENUM columns. 

// Connect to database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Define the specific words for sorting
$specificWords = array("word1", "word2", "word3");

// Construct SQL query with ORDER BY FIELD() function
$query = "SELECT * FROM table_name ORDER BY FIELD(column_name, '" . implode("','", $specificWords) . "')";

// Execute the query
$result = mysqli_query($connection, $query);

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

// Close connection
mysqli_close($connection);

Keywords

PHP MySQL sorting alternative methods output manipulation

Related Questions