我有下表。
条目表描述
+-------------+-------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| title | varchar(255) | YES | | NULL | |
| slug | varchar(255) | YES | | NULL | |
| description | text | YES | | NULL | |
| user_id | int(10) unsigned | NO | | NULL | |
| unsafe | enum('0','1') | NO | | NULL | |
| copyright | enum('0','1') | NO | | 0 | |
| status | enum('0','1','2') | NO | | 0 | |
| date_add | datetime | NO | | NULL | |
+-------------+-------------------+------+-----+---------+----------------+
标签表描述
+-------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+---------+----------------+
| id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| relation_id | int(10) unsigned | NO | | NULL | |
| name | varchar(255) | NO | | NULL | |
+-------------+---------------------+------+-----+---------+----------------+
我想在 Entry.title 和 tag.name 中搜索。此查询的性能如何。
我继续使用全文。你怎么 ?
首先,您需要确保标题和名称字段都已建立索引(无法通过您发送的信息看到这一点。我假设 tag.relation_id 与 entry.id 相关。所以您可以像这样搜索:
SELECT * FROM entry as e JOIN tags as t on e.id = t.relation_id WHERE e.title LIKE('%YOURSEARCH%') OR t.name LIKE('%YOURSEARCH%')
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)