How does using SUBSTRING_INDEX() compare to using stristr in mysqli queries?

When working with MySQL queries in PHP using mysqli, if you need to extract a substring from a string, you can use the SUBSTRING_INDEX() function in your SQL query. This function allows you to specify the delimiter and the occurrence of the delimiter to extract the desired substring. On the other hand, stristr is a PHP function that searches for the first occurrence of a string within another string, which is different from extracting a substring based on a delimiter. 

// Using SUBSTRING_INDEX() in a mysqli query to extract a substring
$mysqli = new mysqli("localhost", "username", "password", "database");

$query = "SELECT SUBSTRING_INDEX(column_name, '@', 1) AS extracted_string FROM table_name";

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

if ($result) {
    while ($row = $result->fetch_assoc()) {
        echo $row['extracted_string'] . "<br>";
    }
} else {
    echo "Error: " . $mysqli->error;
}

$mysqli->close();

Keywords

SUBSTRING_INDEX stristr mysqli queries comparison PHP

Related Questions