How can the SUBSTRING function be used in SQL queries to filter results based on specific criteria in PHP?

To filter results based on specific criteria using the SUBSTRING function in SQL queries in PHP, you can use the SUBSTRING function within the WHERE clause of your SQL query. This function allows you to extract a portion of a string from a column and then compare it to a specific value to filter the results accordingly. By using the SUBSTRING function in this way, you can easily target specific substrings within your data and retrieve only the records that meet your criteria. 

<?php
// Establish a connection to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Define the specific criteria you want to filter by
$substring = "specific_criteria";

// Execute SQL query with SUBSTRING function in WHERE clause
$sql = "SELECT * FROM table_name WHERE SUBSTRING(column_name, start_position, length) = '$substring'";
$result = $conn->query($sql);

// Display the filtered results
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "Column Value: " . $row["column_name"] . "<br>";
    }
} else {
    echo "No results found";
}

// Close the database connection
$conn->close();
?>

Keywords

PHP SQL SUBSTRING filter criteria

Related Questions