SQL WHERE 不包含搜尋
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%’;