【phpMyAdmin】SQL文
例:
条件なし
SELECT * FROM `table1` WHERE 1
例:
条件付き
SELECT * FROM `table1` WHERE `itemid1` = 'abc1234'
SELECT * FROM `table1` WHERE `itemid1` like 'abc%'
SELECT * FROM `table1` WHERE `itemid1` like 'abc%' and `itemid2` like 'xyz%'
参考URL
https://www.w3schools.com/sql/sql_where.asp
例:
NULLの判断
SELECT * FROM `table1` WHERE `itemid1` is NULL
SELECT * FROM `table1` WHERE `itemid1` is not NULL
参考URL
https://www.dbonline.jp/sqlite/select/index7.html