In this case
registered
field isDATETIME
type.
SELECT *
FROM users
WHERE
`registered` >= CONCAT(SUBDATE(CURDATE(), 1), ' 00:00:00') AND
<!DOCTYPE html> | |
<html > | |
<head> | |
<meta charset="UTF-8"> | |
<title>Responsive Table Example</title> | |
<style> | |
@import 'http://fonts.googleapis.com/css?family=Open+Sans:300,400,700'; | |
* { |
#!/bin/bash | |
# Vars | |
java="java" | |
xsltproc="xsltproc" | |
node="node" | |
phantomjs="phantomjs" | |
grunt="grunt" | |
bower="bower" | |
compass="compass" |
/*---------------------------------------------- | |
--Common MQs Min-Width | |
----------------------------------------------- */ | |
$mq-xsmall: 22em; | |
//after iphone | |
$mq-small: 32em; | |
//Tablet ish (main break) | |
$mq-med: 54em; |
/*-------------------------------------------*/ | |
/* Register and enqueue scripts and styles | |
/*-------------------------------------------*/ | |
function jumpoff_scripts_and_styles() { | |
if ( !is_admin() ) { | |
//Register Styles | |
wp_register_style( 'jumpoff_styles',get_template_directory_uri() . '/assets/css/app.min.css', false ); | |
wp_register_style( 'jumpoff_fonts',get_template_directory_uri() . '/assets/css/fonts.min.css', false ); | |
UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl'; | |
UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl'); | |
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl'); | |
UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl'); |
set list
Shows invisible characters.set listchars
What invisibile characters should be set to, see :h listchars
for complete list.map
creates a key map that works in normal, visual, select and operator pending modesmap!
creates a key map that works in insert and command-line mode./*For the calendar/events list page (I just want a white background - it defaults to transparent, and often doesn't look good depending on which child theme you're using. */ | |
#tribe-events-content-wrapper { | |
background: #fff; | |
} | |
/*For the single event page (mess with padding to get the spacing how you want it) */ | |
#tribe-events-pg-template { | |
background: none repeat scroll 0 0 #fff; | |
padding: 20px; | |
margin: 0 auto 30px; |
# Copy file from local to remote server (reverse to copy the other way) | |
scp [filename] [user]@[remote-server]:/tmp/ |