select title from (
select title from {$dbtbpre}ecms_all where title like '%{$keyboard}%'
union all
select title from {$dbtbpre}ecms_mtv where title like '%{$keyboard}%'
) t
order by LENGTH(title)-LENGTH(replace(title,'{$keyboard}','')) desc limit 10select title from (
select title from {$dbtbpre}ecms_all where title like '{$keyboard}%'
union all
select title from {$dbtbpre}ecms_mtv where title like '{$keyboard}%'
) t limit 10
哪个更好呢,谢谢了
select title from {$dbtbpre}ecms_all where title like '%{$keyboard}%'
union all
select title from {$dbtbpre}ecms_mtv where title like '%{$keyboard}%'
) t
order by LENGTH(title)-LENGTH(replace(title,'{$keyboard}','')) desc limit 10select title from (
select title from {$dbtbpre}ecms_all where title like '{$keyboard}%'
union all
select title from {$dbtbpre}ecms_mtv where title like '{$keyboard}%'
) t limit 10
哪个更好呢,谢谢了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货