How can I write an SQL query by using the NOT CONTAINS keyword?

 In the context of Salesforce, here is how you can write an SQL query for your particular Objective:-

Let us assume that you have a “product” table with columns “product I’d” “product name “ and “description”. You want to retrieve the product which do not have the keyword “out of stock” in their description.

First, let’s create a sample “product “ table and insert some data:-

CREATE TABLE products (
    Product_id INT PRIMARY KEY,
    Product_name VARCHAR(50),
    Description VARCHAR(255)
);

INSERT INTO products (product_id, product_name, description)

VALUES

    (1, ‘Product A’, ‘This is a description for Product A’),

    (2, ‘Product B’, ‘Product B is currently out of stock’),

    (3, ‘Product C’, ‘Product C is available for purchase’);

Now you can write the SQL query to retrieve the product that does not contains the keyword out of stock in their description:-

SELECT *
FROM products
WHERE description NOT LIKE ‘%out of stock%’;

Here is the example given of java programming language which would help in implementing the SQL query and process the results:-

Import java.sql.Connection;
Import java.sql.DriverManager;
Import java.sql.PreparedStatement;
Import java.sql.ResultSet;
Import java.sql.SQLException;

Public class ProductDAO {
    Private static final String DB_URL = “jdbc:mysql://localhost:3306/your_database”;
    Private static final String DB_USER = “your_username”;
    Private static final String DB_PASSWORD = “your_password”;
    Public void retrieveProductsNotContainingKeyword(String keyword) {
        Try (Connection connection = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD)) {
            String sqlQuery = “SELECT * FROM products WHERE description NOT LIKE ?”;
            Try (PreparedStatement preparedStatement = connection.prepareStatement(sqlQuery)) {
                preparedStatement.setString(1, “%” + keyword + “%”);
                try (ResultSet resultSet = preparedStatement.executeQuery()) {
                    while (resultSet.next()) {
                        int productId = resultSet.getInt(“product_id”);
                        String productName = resultSet.getString(“product_name”);
                        String description = resultSet.getString(“description”);
                        // Process the retrieved data (e.g., display, store in Java objects)
                        System.out.println(“Product ID: “ + productId);
                        System.out.println(“Product Name: “ + productName);
                        System.out.println(“Description: “ + description);
                        System.out.println();
                    }
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    Public static void main(String[] args) {
        ProductDAO productDAO = new ProductDAO();
        productDAO.retrieveProductsNotContainingKeyword(“out of stock”);
    }
}