SQL WHERE 不包含搜尋 – jashliao部落格

SQL WHERE 不包含搜尋

資料來源:http://www.fooish.com/sql/in.html
http://www.blueshop.com.tw/board/FUM200410061525290EW/BRD200509131014496W1.html

Select * Form k_db Where [name] not like ‘%time%’

SELECT * FROM customers WHERE Name NOT IN (‘張一’, ‘李三’);

//實際在GOOGLE GA的phpmyadmin執行OK
SELECT * FROM `all` WHERE url not like ‘%http%’;
DELETE FROM `all` WHERE url not like ‘%http%’;