SQL Query Does Not Contain

Last Updated On Thursday 11th Nov 2021

sql string does not contain

SQL query to find rows where row does not contain myword

	SELECT * FROM table WHERE field1 NOT LIKE '%$x%';
	
	SELECT * FROM table WHERE row NOT LIKE '%myword%';
	

The Above discover all the rows where a does not contain “myword”.