Zi 字媒體

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%’;