SQL查询,其中字段不包含$ x(SQL Query Where Field DOES NOT Contain $x)
我想找到一个SQL查询来查找field1不包含$ x的行。 我该怎么做?
I want to find an SQL query to find rows where field1 does not contain $x. How can I do this?
原文:https://stackoverflow.com/questions/232935
最满意答案
这种类型的布局可以通过堆叠自举网格元素轻松实现,以创建您在页面上看到的三个部分; 菜单,内容,页脚。 菜单项可以通过使用bootstraps下拉菜单来实现,你只需要按照你想要的样式来设计它们。
这是该布局的基本细分:
HTML
<div class="content"> <div class="container"> <div class="row"> <div class="span12"> ...navbar... </div> </div> <div class="row"> <div class="span8 offset2"> ...content... </div> </div> </div> </div> <div class="container"> <div class="row"> <div class="span2"> ...list menu... </div> <div class="span2"> ...list menu... </div> <div class="span2"> ...list menu... </div> <div class="span2 pull-right"> ...dropup menu... </div> </div> </div>
有了这个,你可以很容易地填写元素,就像这样:
HTML
<div class="content"> <div class="container"> <div class="row"> <div class="span12"> <div class="navbar"> <div class="navbar-inner"> <div class="container"> <a data-target=".nav-collapse" data-toggle="collapse" class="btn btn-navbar"> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </a> <div class="nav-collapse"> <div class="btn-group pull-right"> <a data-toggle="dropdown" class="btn btn-simple dropdown-toggle" href="#"><i class="icon-fire"></i> Dropdown <b class="caret"></b></a> <div class="dropdown-menu" style="padding: 15px; padding-bottom: 0px;"> <form> <input style="margin-bottom: 15px;" type="text"> <input style="margin-bottom: 15px;" type="password"> <input style="float: left; margin-right: 10px;" type="checkbox"> <label for="user_remember_me"> Remember me</label> <input class="btn btn-primary" style="clear: left; width: 100%; height: 32px; font-size: 13px;" value ="Submit" type="submit"> </form> </div> </div> </div><!-- /.nav-collapse --> </div> </div><!-- /navbar-inner --> </div> </div> </div> <div class="row"> <div class="span8 offset2"> <h1>Title</h1> <a class="play" href="#"> <img src="https://www.dropbox.com/static/images/watch_a_video2.png"> </a> <div class="big-btn"> <a href="#" class="btn btn-primary">Download</a> </div> </div> </div> </div> </div> <div class="container"> <div class="row"> <div class="span2"> <ul> <li>Lorem ipsum dolor sit amet</li> <li>Consectetur adipiscing elit</li> <li>Integer molestie lorem at massa</li> <li>Facilisis in pretium nisl aliquet</li> <li>Nulla volutpat aliquam velit</li> </ul> </div> <div class="span2"> <ul> <li>Lorem ipsum dolor sit amet</li> <li>Consectetur adipiscing elit</li> <li>Integer molestie lorem at massa</li> <li>Facilisis in pretium nisl aliquet</li> <li>Nulla volutpat aliquam velit</li> </ul> </div> <div class="span2"> <ul> <li>Lorem ipsum dolor sit amet</li> <li>Consectetur adipiscing elit</li> <li>Integer molestie lorem at massa</li> <li>Facilisis in pretium nisl aliquet</li> <li>Nulla volutpat aliquam velit</li> </ul> </div> <div class="span2 pull-right"> <div class="btn-group dropup pull-right"> <a href="#" data-toggle="dropdown" class="btn btn-simple dropdown-toggle"><i class="icon-globe"></i> Inverse <span class="caret"></span></a> <ul class="dropdown-menu"> <li><a href="#">Action</a></li> <li><a href="#">Another action</a></li> <li><a href="#">Something else here</a></li> <li><a href="#">Separated link</a></li> </ul> </div> </div> </div> </div>
将一些CSS爱融入混合,你有一个炖菜去:
CSS 非常脏的CSS,仅用于演示目的
.content { text-align:center; margin:0 0 60px; } .navbar-inner { background-color: transparent; background-image: none; background-repeat: no-repeat; box-shadow: none; color:black; } .navbar .nav > li > a { color:black; text-shadow:none; } .navbar .nav > li > a:hover { color:#333; } .navbar .nav li.dropdown .dropdown-toggle .caret, .navbar .nav li.dropdown.open .caret { border-bottom-color: #000000; border-top-color: #000000; } .btn-simple { background-color:transparent; background-image:none; } .big-btn { margin: 80px 0 108px; } .big-btn .btn { border-radius: 6px 6px 6px 6px; display: inline-block; font-size: 30px; line-height: 1; margin-bottom: 27px; padding: 19px 24px; text-align: center; width: 60%; } .navbar-inner { padding-left: 0; padding-right: 0; } .play { margin:20px 0; display:block; }
This type of layout can be easily achieved by stacking up the bootstrap grid elements to create the three sections you see on the page; menu, content, footer. The menu items can be implemented by using the bootstraps drop-down menus, you just have to style them the way you want.
This is a basic breakdown of that layout:
HTML
<div class="content"> <div class="container"> <div class="row"> <div class="span12"> ...navbar... </div> </div> <div class="row"> <div class="span8 offset2"> ...content... </div> </div> </div> </div> <div class="container"> <div class="row"> <div class="span2"> ...list menu... </div> <div class="span2"> ...list menu... </div> <div class="span2"> ...list menu... </div> <div class="span2 pull-right"> ...dropup menu... </div> </div> </div>
With this in hand, you can fill in the elements quite easily, like so:
HTML
<div class="content"> <div class="container"> <div class="row"> <div class="span12"> <div class="navbar"> <div class="navbar-inner"> <div class="container"> <a data-target=".nav-collapse" data-toggle="collapse" class="btn btn-navbar"> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </a> <div class="nav-collapse"> <div class="btn-group pull-right"> <a data-toggle="dropdown" class="btn btn-simple dropdown-toggle" href="#"><i class="icon-fire"></i> Dropdown <b class="caret"></b></a> <div class="dropdown-menu" style="padding: 15px; padding-bottom: 0px;"> <form> <input style="margin-bottom: 15px;" type="text"> <input style="margin-bottom: 15px;" type="password"> <input style="float: left; margin-right: 10px;" type="checkbox"> <label for="user_remember_me"> Remember me</label> <input class="btn btn-primary" style="clear: left; width: 100%; height: 32px; font-size: 13px;" value ="Submit" type="submit"> </form> </div> </div> </div><!-- /.nav-collapse --> </div> </div><!-- /navbar-inner --> </div> </div> </div> <div class="row"> <div class="span8 offset2"> <h1>Title</h1> <a class="play" href="#"> <img src="https://www.dropbox.com/static/images/watch_a_video2.png"> </a> <div class="big-btn"> <a href="#" class="btn btn-primary">Download</a> </div> </div> </div> </div> </div> <div class="container"> <div class="row"> <div class="span2"> <ul> <li>Lorem ipsum dolor sit amet</li> <li>Consectetur adipiscing elit</li> <li>Integer molestie lorem at massa</li> <li>Facilisis in pretium nisl aliquet</li> <li>Nulla volutpat aliquam velit</li> </ul> </div> <div class="span2"> <ul> <li>Lorem ipsum dolor sit amet</li> <li>Consectetur adipiscing elit</li> <li>Integer molestie lorem at massa</li> <li>Facilisis in pretium nisl aliquet</li> <li>Nulla volutpat aliquam velit</li> </ul> </div> <div class="span2"> <ul> <li>Lorem ipsum dolor sit amet</li> <li>Consectetur adipiscing elit</li> <li>Integer molestie lorem at massa</li> <li>Facilisis in pretium nisl aliquet</li> <li>Nulla volutpat aliquam velit</li> </ul> </div> <div class="span2 pull-right"> <div class="btn-group dropup pull-right"> <a href="#" data-toggle="dropdown" class="btn btn-simple dropdown-toggle"><i class="icon-globe"></i> Inverse <span class="caret"></span></a> <ul class="dropdown-menu"> <li><a href="#">Action</a></li> <li><a href="#">Another action</a></li> <li><a href="#">Something else here</a></li> <li><a href="#">Separated link</a></li> </ul> </div> </div> </div> </div>
Sprinkle some CSS love into the mix and you got a stew going:
CSS extremely dirty css, used for demo purposes only
.content { text-align:center; margin:0 0 60px; } .navbar-inner { background-color: transparent; background-image: none; background-repeat: no-repeat; box-shadow: none; color:black; } .navbar .nav > li > a { color:black; text-shadow:none; } .navbar .nav > li > a:hover { color:#333; } .navbar .nav li.dropdown .dropdown-toggle .caret, .navbar .nav li.dropdown.open .caret { border-bottom-color: #000000; border-top-color: #000000; } .btn-simple { background-color:transparent; background-image:none; } .big-btn { margin: 80px 0 108px; } .big-btn .btn { border-radius: 6px 6px 6px 6px; display: inline-block; font-size: 30px; line-height: 1; margin-bottom: 27px; padding: 19px 24px; text-align: center; width: 60%; } .navbar-inner { padding-left: 0; padding-right: 0; } .play { margin:20px 0; display:block; }
相关问答
更多-
这种类型的布局可以通过堆叠自举网格元素轻松实现,以创建您在页面上看到的三个部分; 菜单,内容,页脚。 菜单项可以通过使用bootstraps下拉菜单来实现,你只需要按照你想要的样式来设计它们。 这是该布局的基本细分: HTML...navbar... ...
Flask登陆页面联系表格(Flask landing page contact form)[2023-08-29]
这里有一个很好的例子https://github.com/jawr/flask-contact/blob/master/main.py这里的详细步骤http://code.tutsplus.com/tutorials/intro-to-flask-加入-A-联系方式页-网28982 我还建议你使用一些第三方服务作为邮件服务器(Mandrill等)。 here is a good examples for you https://github.com/jawr/flask-contact/blob/maste ...问题1: 第二个jQuery库有问题。 当我单击提交按钮时,会引发以下错误消息: TypeError: $.ajax is not a functi ...触发标记基于着陆页(Trigger tag based on landing page)[2022-06-25]
GTM没有任何类型的持久性内存,也无法将变量从一个页面转移到另一个页面。 因此,您需要自己设置一个cookie,并在后续页面中查找它。 设置JS cookie的绝对准系统代码是: document.cookie = "key=value"; 这将设置第一方会话cookie与名称“key”和当前域上的valie“值”。 这对你来说实际上可能就足够了(会话cookie意味着如果浏览器关闭,cookie将会过期,这听起来像你想要的,否则你可以添加一个到期日等 )。 您无需担心读取cookie的代码,因为这是GT ...工作小提琴 。 您可以使用在每个克隆中调用的select模型,然后在克隆之后初始化选择,如下面显示的代码段: $('#add').click(function() { var n = $('.car-list').length + 1; var temp = $('.form-group:last').clone(true).removeClass('select-car'); $('.control-label:first', temp).html('Select car #' + ...第一:是的,PayPal不断测试以改善他们的流量,因此他们将进行A | B测试。 特别是两个按钮文本听起来像是经典的A | B测试,并且可能在未来将采用具有最高转换率(这意味着商家的最大销售额)的任何测试作为100%解决方案。 PayPal还检查cookie以尝试向每个买家提供最佳,最可能转换的页面(例如,如果有活跃的PayPal cookie使PayPal登录突出;没有PayPal cookie使直接卡片输入更加突出)。 再次这样做是为了提高总转换率。 你可以努力打败/超越这些选择,但我不推荐它; 通过强 ...好的,您可以使用任何控制器来设置主页,例如: ApplesController def home # intialize instance variable for home page here end . . . . . end 在app / views / apples / home.html.erb中创建视图文件 在你的路线 route "apples#home" Ok, you can use any of your controllers to setup the home ...Rails登陆页面(Rails landing pages)[2023-10-14]
使用会话变量来跟踪未登录的访问者是否已查看登录页面。 有点像: def index if !logged_in? && !session[:visited_welcome_page] redirect_to welcome_path else # Render the main view of goldhat.org end end def welcome session[:visited_welcome_page] = true # Render welcome vi ...我可以回答你的一些问题: 1)将服务器端API转换为返回JSON数据的REST样式 是 问题:我可以使用动态HTML加载AngularJS。 我猜是。 不知道怎么样? 目前我在服务器端使用velocity Templates来填充HTML模板中的数据并将其作为响应发送到AJAX中? 如果我尝试使用AngularJS会有什么变化? 如果我理解你,你想在服务器端生成模板。 在这种情况下 - 您只需要AngularJs - 您的视图在服务器上预先填充,浏览器接收静态内容(从客户端的角度来看)。 如果您想使用Ang ...设计注册登陆页面(Devise Sign Up Landing page)[2021-09-21]
删除helper_method : #app/helpers/application_helper.rb` module ApplicationHelper def resource_name :user end def resource @resource ||= User.new end def devise_mapping @devise_mapping ||= Devise.mappings[:user] end end 正如文档所述 ... ...相关文章
更多- MongoDB学习 (五):查询操作符(Query Operators).1st
- solr delete query
- solr delete query
- Solr4.7---Field、CopyField、DynamicField
- 关于struts1.x 和struts2 的问题
- 常用HQL(Hibernate Query Language)查询
- Solr 使用自定义 Query Parser
- Solr 使用自定义 Query Parser
- solr学习笔记二-------solr query查询的参数
- Mysql错误:Ignoring query to other database解决方法
最新问答
更多- 散列包括方法和/或嵌套属性(Hash include methods and/or nested attributes)
- TensorFlow:基于索引列表创建新张量(TensorFlow: Create a new tensor based on list of indices)
- 企业安全培训的各项内容
- 错误:RPC失败;(error: RPC failed; curl transfer closed with outstanding read data remaining)
- NumPy:将int64值存储在np.array中并使用dtype float64并将其转换回整数是否安全?(NumPy: Is it safe to store an int64 value in an np.array with dtype float64 and later convert it back to integer?)
- 注销后如何隐藏导航portlet?(How to hide navigation portlet after logout?)
- 将多个行和可变行移动到列(moving multiple and variable rows to columns)
- 对setOnInfoWindowClickListener的意图(Intent on setOnInfoWindowClickListener)
- Angular $资源不会改变方法(Angular $resource doesn't change method)
- 如何配置Composite C1以将.m和桌面作为同一站点提供服务(How to configure Composite C1 to serve .m and desktop as the same site)
- 不适用:悬停在悬停时:在元素之前[复制](Don't apply :hover when hovering on :before element [duplicate])
- Mysql DB单个字段匹配多个其他字段(Mysql DB single field matching to multiple other fields)
- 产品页面上的Magento Up出售对齐问题(Magento Up sell alignment issue on the products page)
- 是否可以嵌套hazelcast IMaps?(Is it possible to nest hazelcast IMaps? And whick side effects can I expect? Is it a good Idea anyway?)
- UIViewAnimationOptionRepeat在两个动画之间暂停(UIViewAnimationOptionRepeat pausing in between two animations)
- 在x-kendo-template中使用Razor查询(Using Razor query within x-kendo-template)
- 在BeautifulSoup中替换文本而不转义(Replace text without escaping in BeautifulSoup)
- 如何在存根或模拟不存在的方法时配置Rspec以引发错误?(How can I configure Rspec to raise error when stubbing or mocking non-existing methods?)
- asp用javascript(asp with javascript)
- “%()s”在sql查询中的含义是什么?(What does “%()s” means in sql query?)
- 如何为其编辑的内容提供自定义UITableViewCell上下文?(How to give a custom UITableViewCell context of what it is editing?)
- c ++十进制到二进制,然后使用操作,然后回到十进制(c++ Decimal to binary, then use operation, then back to decimal)
- 以编程方式创建视频?(Create videos programmatically?)
- 无法在BeautifulSoup中正确解析数据(Unable to parse data correctly in BeautifulSoup)
- webform和mvc的区别 知乎
- 如何使用wadl2java生成REST服务模板,其中POST / PUT方法具有参数?(How do you generate REST service template with wadl2java where POST/PUT methods have parameters?)
- 我无法理解我的travis构建有什么问题(I am having trouble understanding what is wrong with my travis build)
- iOS9 Scope Bar出现在Search Bar后面或旁边(iOS9 Scope Bar appears either behind or beside Search Bar)
- 为什么开机慢上面还显示;Inetrnet,Explorer
- 有关调用远程WCF服务的超时问题(Timeout Question about Invoking a Remote WCF Service)