Zend_Db 哪里不

发布于 2024-12-09 05:02:32 字数 241 浏览 0 评论 0原文

我需要使用 Zend_Db 构建这样的查询：

SELECT * FROM mytable
WHERE NOT (field1 = 0.00 AND field2 = 0.00  AND field3 = 0.00);

How can I Achieve this with Zend_Db, MySQL 方法是否正确？（如果所有三个字段均为 0.00，则忽略它）。

感谢您的回复！

原文

I'm in need of building a query like this in with Zend_Db:

SELECT * FROM mytable
WHERE NOT (field1 = 0.00 AND field2 = 0.00  AND field3 = 0.00);

How can I accomplish this with Zend_Db, also is the MySQL approach correct? (if all three fields are 0.00 then ignore it).

Thanks for the replies!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

数理化全能战士 2024-12-16 05:02:32

我认为应该这样做：

$db->select()
    ->from('mytable')
    ->where('field1 != 0.00')
    ->where('field2 != 0.00')
    ->where('field3 != 0.00');

I think this should do it:

$db->select()
    ->from('mytable')
    ->where('field1 != 0.00')
    ->where('field2 != 0.00')
    ->where('field3 != 0.00');

回复收藏 0 原文

撩心不撩汉 2024-12-16 05:02:32

我认为应该是

$query = $this->select()
              ->from('mytable')
              ->where('field1 <> ? AND field2 <> ? AND field3 <> ?', 0, 2) /*2 is Zend_Db::FLOAT_TYPE*/

I think it should be

$query = $this->select()
              ->from('mytable')
              ->where('field1 <> ? AND field2 <> ? AND field3 <> ?', 0, 2) /*2 is Zend_Db::FLOAT_TYPE*/

回复收藏 0 原文

~没有更多了~