Ads by ProfitSence

SQL Query Does Not Contain

Last Updated on Wednesday 5th Oct 2022

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".