简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

php?sql语句解决方法

WBOY
Release： 2016-06-13 12:27:08
Original
765 people have browsed it

php?sql语句


我想查出 开始日期（event_start_time）或 结束日期(event_end_time)在 2015-11的所有数据
这个 where 语句要怎么写？
------解决思路----------------------
.... where data_format(event_start_time, '%Y-%m') = '2015-11' or data_format(event_end_time, '%Y-%m') = '2015-11'

Related labels：
event format nbsp time
source：php.cn
Previous article：php自学擢升进阶路线 Next article：谁能写个demo参观一下呀，小弟我翻阅了不少资料还是没有能理解
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Preserve font spacing for a line of text split into separate HTML elements I'm trying to recreate a common technique of splitting words into separate HTML elements s...
From 2023-09-10 18:37:01
0
1
301
How to make this automatically multiline How to make this automatically multiline I'm using HTML and CSS Here is my code (I modifie...
From 2023-08-18 00:10:50
0
1
329
Why is mine wrong in the console? if (time<8) { x="zao";}else{ x="good";}Which problem
From 2023-08-03 14:42:30
0
0
99
Is this the code for conn.php? 下面<?php     $name = $_POST['username'];    $pwd  = md5($_POST['password']);    $sql = &...
From 2023-06-08 18:46:23
0
1
143
After downloading COMPOSER and installing TP6, it always fails to install, as shown in the picture. What do you want? After downloading COMPOSER and installing TP6, it always fails to install, as shown in the...
From 2023-04-01 22:49:35
0
0
632
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！