首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >从表Mysql中选择not null值

问从表Mysql中选择not null值
EN

Stack Overflow用户
提问于 2017-07-23 15:48:07
回答 2查看 61关注 0票数 0

伙计们,我在表中选择not null值时有问题。

代码语言:javascript
复制
$tabelka = mysql_fetch_array(mysql_query("select * from ".$server_db.".paczka_przedmiot where cos = ".$losuj['test1']." 
or cos = ".$losuj['test2']."
or cos = ".$losuj['test3']."
or cos = ".$losuj['test4']."
or cos = ".$losuj['test5']."
or cos = ".$losuj['test6']." order by rand() limit 1"));
$szansa = rand(1,100000);

我尝试使用add和(因为不是空的),但是这里不工作,这是我的完整代码

代码语言:javascript
复制
$tabelka = mysql_fetch_array(mysql_query("select * from ".$server_db.".paczka_przedmiot where cos = ".$losuj['test1']." 
or cos = ".$losuj['test2']."
or cos = ".$losuj['test3']."
or cos = ".$losuj['test4']."
or cos = ".$losuj['test5']."
or cos = ".$losuj['test6']."  and (cos IS NOT NULL) order by rand() limit 1"));
$szansa = rand(1,100000);
EN

回答 2

Stack Overflow用户

回答已采纳

发布于 2017-07-23 16:07:51

您可以使用替代查询,但这不是一个标准:

代码语言:javascript
复制
SELECT *
FROM table 
WHERE NOT (YourColumn <=> NULL);

您还应该使用大写“和”。

你也可以试试这个:

代码语言:javascript
复制
mysql_fetch_array(mysql_query("select * from ".$server_db.".paczka_przedmiot where cos IS NOT NULL AND (cos = ".$losuj['test1']. " 
OR cos = ".$losuj['test2']. "
OR cos = ".$losuj['test3']. "
OR cos = ".$losuj['test4']. "
OR cos = ".$losuj['test5']. "
OR cos = ".$losuj['test6']. ") ORDER BY rand() LIMIT 1"));
票数 1
EN

Stack Overflow用户

发布于 2017-07-23 22:10:52

恐怕问题就在括号里。这一更正应该有效(注意括号):

代码语言:javascript
复制
$tabelka = mysql_fetch_array(mysql_query("select * from ".$server_db.".paczka_przedmiot where (cos = ".$losuj['test1']." 
or cos = ".$losuj['test2']."
or cos = ".$losuj['test3']."
or cos = ".$losuj['test4']."
or cos = ".$losuj['test5']."
or cos = ".$losuj['test6']." ) and (cos IS NOT NULL) order by rand() limit 1"));
$szansa = rand(1,100000);
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/45266992

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档