SQL Query Where Field DOES NOT Contain $x

In SQL, if we want to filter the rows that do not contain the $x as a property, we can use the NOT LIKE operator. In this blog, we will learn how we can filter the rows that do not contain $x as a value.

Table of Contents:

• SQL Query Where Field DOES NOT Contain $x
  • Syntax
  • Example of NOT LIKE Operator
• Conclusion

SQL Query Where Field DOES NOT Contain $x

In SQL, if we want to print those rows that do not contain $x as their values, we have to use the NOT LIKE Operator. Let’s have a look at the syntax of the NOT LIKE operator.

Syntax:

SELECT *
FROM your_table
WHERE column_name NOT LIKE '%$x%';

Example of NOT LIKE Operator:

Suppose we have a table Customer, and we have to print the fields that do not contain $x.

Now let’s print only those rows, that do not contain $x in their email.

Query:

SELECT CustomerID, CustomerName, Email
FROM Customers
WHERE Email NOT LIKE '%$x%';

Output:

Explanation: the above query will filter the last two rows that contain $x as their string, and return the rest rows.

Conclusion

So far in this article, we have learned how we can print the roes that do not contain a particular string in it. If you want to excel in your career in SQL, you may refer to our SQL Course.

Discover our collection of insightful SQL blogs that will help you master the art of managing and querying your databases efficiently.

• Troubleshoot- failed to initialize sqlcmd library with error number -2147467259
• Date Time format to SQL format using C#
• Finding row index containing maximum value using R
• What do < and > stand for?
• SQL query for finding records where count > 1