Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
MySQL: comparison including "IS NULL" cases
CREATE temporary table tmp (id int,name varchar(16),core_name varchar(16), type varchar(16),source varchar(16) null); INSERT INTO tmp values (31,'FTSE','FTSE','factor',NULL), (32,'FT-SE','FTSE','factor',NULL),(33,'FTSEEE','FTSE','factor','something'),(33,'abc FTSE','FTSE','factor','abc'); select * from tmp where name like '%FTSE%' AND (source != 'abc' OR source is null)
run
|
edit
|
history
|
help
0
BASE DE DATOS
JA
itm
user data by unspecific date, according to param "last entry, last but one, last but two, etc."
saikatd
Wenfeng Ou
Charles Chung
mysql - update
calculate averages for students and levels
Amp