select * from article where title like '%"+search+"%' order by time
union
select * from article where contents like '%"+search+"%' order by time
2条回答
-
采纳
点赞 评论 复制链接分享
-
采纳
如果前端给你两个参数，你想要的最后结果是想要article表的title和contents字段里的内容都要能和前端给的参数匹配的话，应该不用将两个结果整合一条sql应该就满足了
select * from article where title like '%参数1%' and contents like '%参数2%' order by 时间那一列 ；点赞 评论 复制链接分享
提交
相关推荐
- 2年前回答 2 已采纳 比如我有一个article表，前端搜索文章内容是给参数search，我想要的是先查询article的title 是否有匹配字段并按照时间排序，然后再查询article的contents是否匹配字段，并按照时间排序，然后再把这连个查询结果整合返回给前端，该怎么设计查询语句啊？
- 回答 4 已采纳 第一个查询语句  第二个查询语句  想要的查询结果 
- 8年前回答 2 已采纳 This is my table : question id | name -----+----- 2 | name 1 3 | name 2 4 | name 3 5 | name 4 10 | name 5 20 | name 6 21 | name 7 I have an id say 5, I need to get the previous and next rows, so if id is 5 I need to get 4, 5 and 10 Now I am using these queries select * from question where id = (select max(id) from question where id < 5); select * from question where id = (select min(id) from question where id > 5); What I am looking is for a single query (if its possible). Some thing like SELECT xx AS prevId, id, yy AS nextId FROM questions WHERE ....... If there is not previous id or next id it should be 0 or -1 For example id: 5 Return : 4, 5, 10 id:2 Return : -1, 2, 3 id: 21 Return 20, 21, -1 I know how to do this with multiple queries and with some if conditions in PHP, but I am looking for a pure mySQL approach if its possible.
- 7年前回答 2 已采纳 I have a table ('names') which includes data related with other data in other tables relying on ids. For example: *Names table id | name | predecessor | successor | house | birthplace ----------------------------------------------------------------- 10 Bayezid II 9 11 4 NULL 11 Selim I 10 12 4 5 12 Suleiman 11 13 4 61 *Houses table id | house -------------- 4 House of Osman *Places table id | place -------------- 5 Amasya 61 Trabzon What I'm trying to accomplish is to construct a query which results in returning whole information depending on the id, like: {"result":[{ "id":"11", "name":"Selim I", "predecessor": "Bayezid II", "successor": "Suleiman", "house":"House of Osman", "birthplace":"Amasya" }]} So, the name of the house and the birthplace are brought from other tables ('houses', 'places') whereas the predecessor and the successor are from the same table. I need help constructing this query. Thank you.
- 7年前回答 2 已采纳 Is there any syntax like WHERE IN allow me to update multiple values at once? example: update files set name = 'untitled' WHERE id IN (1,2,3,4) become: update files set name ( 'untitled', 'untitled2', 'untitled3', 'untitled4' ) WHERE id IN (1,2,3,4) My script contains an associative array, I need to update the name column set as array value where the id column match the array key
- 回答 1 已采纳 如图中例子:  ``` SELECT cust_name,cust_contact FROM customers,orders,orderitems WHERE customers.cust_id = orders.cust_id AND orderitems.order_num = orders.order_num AND prod_id = 'TNT2'; ``` 这里的顺序是,先过滤出最后一行中orders.prod_id='TNT2'd的产品,然后用返回的行去匹配orderitems.order_num的行,最后用结果去匹配customers.cust_id,然后返回最后匹配的行. 问题1.为什么是这个顺序?虽然逻辑上是正确的,但mysql语言并没有逻辑吧,只能按照我们给的语句去执行.有同学说从左到右从上到下,那也不对啊?也有同学说按照驱动表,先过滤驱动表中的数据,RBO中一般情况下是from后最后一张是驱动表，CBO中输出数据量最少的是驱动表.但这么看也不对啊? 问题2.怎么去总结WHERE字句中有多个条件时执行的顺序? 问题3.假设使用INNER JOIN字句,条件在ON字句中给出时,顺序是否跟WHERE字句一样? 最后先谢谢解答的大神
- 回答 2 已采纳 如数据 YJV-3*50+1*25 取最大值50 JKLGYJ-1-120/20 取最大值120 YJV-4*70+1*35 取最大值70 利用数据库自带函数或自己建立函数或其它方法实现都可以 望大家多多帮助
- 回答 1 已采纳 在mysql数据库中有一表table，根据两列 ip,cookie。通过这两列去除重复记录后统计个数 ip-------cookie 1.1.1.1-----123456 1.1.1.1-----123478 1.1.1.1-----123654 1.1.1.1-----123456 查询后得出 ip-------cookie 1.1.1.1-----123456 1.1.1.1-----123478 1.1.1.1-----123654 统计数：3
- 回答 1 已采纳 Problem: I want to run this query in cakephp 3 SELECT medicine_records.*, medicines.name AS medicine_name, medicines.subname AS `medicine_subname` FROM medicine_records INNER JOIN medicines ON medicines.id = medicine_records.medicine_id Controller: $medicines = $this->MedicineRecords->find()->contain(['Medicines'])->all(); Cakephp Queries log: 2017-02-14 09:58:47 Debug: duration=1 rows=1 SELECT MedicineRecords.id AS `MedicineRecords__id`, MedicineRecords.user_id AS `MedicineRecords__user_id`, MedicineRecords.medicine_id AS `MedicineRecords__medicine_id`, MedicineRecords.times_pre_day AS `MedicineRecords__times_pre_day`, MedicineRecords.created AS `MedicineRecords__created`, MedicineRecords.modified AS `MedicineRecords__modified`, Medicines.id AS `Medicines__id`, Medicines.name AS `Medicines__name`, Medicines.subname AS `Medicines__subname`, Medicines.type AS `Medicines__type`, Medicines.created AS `Medicines__created`, Medicines.modified AS `Medicines__modified` FROM medicine_records MedicineRecords INNER JOIN medicines Medicines ON Medicines.id = (MedicineRecords.medicine_id) Result data: "data": [ { "id": 1, "user_id": 1, "medicine_id": 3, "times_pre_day": 2, "created": "2017-02-14T04:55:48+00:00", "modified": "2017-02-14T04:55:48+00:00", "medicine": { "id": 3, "name": "Name", "subname": "Subname", "type": 1, "created": "2017-02-13T09:38:48+00:00", "modified": "2017-02-13T09:38:48+00:00" } } ] This result has medicine in child level. I want all data in top level like this: "data": [ { "id": 1, "user_id": 1, "medicine_id": 3, "times_pre_day": 2, "medicine_name": "Name", "medicine_subname": "Subname", "created": "2017-02-14T04:55:48+00:00", "modified": "2017-02-14T04:55:48+00:00", } ] I already try to use public $recursive = -1; but I think it not working on Cakephp 3. Update Remove WHERE medicine_records.id = 1
- 回答 3 已采纳 I'm trying to update 2 tables tbl_loanledger and tbl_journal at the same time. Both tables have the same columns such as modified_by, date_modified and deleted. When I try to run this I enter code here I'm getting an error : Error Number: 1052 Column 'modified_by' in field list is ambiguous UPDATE `loan_ledger` as a, journal as b SET `modified_by` = '1', `date_modified` = '2016-06-08', `deleted` = 1 WHERE `a`.`id` = '823' AND `b`.`id` = '823' Filename: C:\xampp\htdocs\system\system\database\DB_driver.php Line Number: 331 Is this the right way on how to update 2 tables in codeigniter? Model public function delete($id){ $data = array( 'modified_by' => $this->ion_auth->user()->row()->id, 'date_modified' => date("Y-m-d"), 'deleted' => 1 ); $this->db->set($data); $this->db->where('a.id', $id); $this->db->where('b.id', $id); $this->db->update('loan_ledger as a, journal as b'); } But if I am just updating single table, it is working, here is a the code: public function delete($id){ $data = array( 'modified_by' => $this->ion_auth->user()->row()->id, 'date_modified' => date("Y-m-d"), 'deleted' => 1 ); $this->db->where('id', $id); $this->db->update(tbl_loanledger, $data); }
- ThinkWon的博客 数据库三大范式是什么mysql有关权限的表都有哪几个MySQL的binlog有有几种录入格式？分别有什么区别？数据类型mysql有哪些数据类型引擎MySQL存储引擎MyISAM与InnoDB区别MyISAM索引与InnoDB索引的区别？InnoDB引擎的4...
- 3年前qq_35548288的博客 之前遇到过一个问题,mysql数据库中有两个表,一张地址表存放省市区等位置信息,另一张用户表里存在三个字段分别对应地址表中的三个位置信息(很奇怪的表格式),如图: 现在需要查询user表中的数据,并根据user表中省市...
- 3年前xingyangs的博客 如何使用操作符UNION、UNION ALL、INTERSECT和EXCEPT把多个SQL查询组合为一个。
- Shiner_的博客 mysql中有种可以通过join相关操作进行表与表之间的方式查询不同结果集,但是在一对多的情况下,关键查询的结果是多条的.例如:班级和学习的关系,我想很直观的看到班级和学生的情况,列表显示出班级的信息和班级的男生...
- 3年前小魏同学i的博客 多表查询如果不加任何条件，得到的结果称为笛卡尔积。 例如，查找雇员名、雇员工资以及部门所在的名字。 可以发现，结果是这样的，从第一个表中选出第一条记录，和第二个表中的所有所有记...
- 编程一只蝶的博客 利用union关键字，可以给出多条select语句，并将它们的结果组合成单个结果集。合并时，两个表对应的列数和数据类型必须相同。各个select语句之间使用union或union all 关键字分隔。union不使用关键字all，执行的时候...
- 4年前淘杯茶的博客 需求：关联查询另一个大表数据的某些（一个以上）字段 方案：因关联查询的表数据太大。多表查询影响效率，单个子查询又有些多余。所以采用多列拼接子查询，然后根据SUBSTRING_INDEX(SOURCE,SEPARETOR,INDEX+1)。 ...
- 3年前linmengmeng_1314的博客 在做毕业设计时，对数据库的查询用到了多表查询， 之前学的一知半解的，借着这个机会，又查了些资料，复习了一下，记录下来，以便日后用到时能快速解决问题。 下面实例中用到的是 MySQL：mysql-5.7.13-winx64， ...
- mclt2017的博客 像图1这种情况，前面的字段内容全部都一样，只有其中一个字段的内容不一样，就可以把这些字段的数据整在一查询结果的字段里： sql语句： select uid,LXR,等等其他字段,GROUP_CONCAT(clcpmc separator'、') group ...
- 3年前Zeus_龙的博客 实际应用大部分情况下，查询语句都会涉及到多张表格 :1.1 多表连接有哪些分类?1.2 针对这些分类有哪些连接方法?1.3 这些连接方法分别作用于哪些应用场景?这篇针对这三个点通过实例来讲述，目的是穷尽所有的场景和...