【phpMyAdmin】SQL文

phpMyAdminSQL

例:

条件なし 

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