Are there potential performance issues when using FIND_IN_SET in a MySQL query for ordering results in PHP?

Using FIND_IN_SET in a MySQL query for ordering results in PHP can potentially cause performance issues, especially when dealing with large datasets. To solve this issue, it's recommended to avoid using FIND_IN_SET for ordering and instead consider restructuring the database schema or using a different approach for sorting the results.

// Example of using a different approach for sorting results without FIND_IN_SET
$query = "SELECT * FROM table_name ORDER BY field_name ASC";
$result = mysqli_query($connection, $query);

if ($result) {
    while ($row = mysqli_fetch_assoc($result)) {
        // Process each row
    }
} else {
    echo "Error: " . mysqli_error($connection);
}