表索引优化like查询

最新推荐文章于 2024-06-18 21:52:50 发布

qq_34091038

最新推荐文章于 2024-06-18 21:52:50 发布

阅读量72

点赞数 2

文章标签：数据库

本文链接：https://blog.csdn.net/qq_34091038/article/details/139706026

版权

		// 构建查询
		$query = $dataModel->field('mobile')
			->where($structureWhere)->where($where)
		    ->whereRaw("MATCH(mobile) AGAINST(:mobile IN BOOLEAN MODE)")
		    ->bind(['mobile' => $matchmobile]);
		
		// 执行查询
		$res_l = $query->find();
			
		//echo db::getlastsql();
		//p($res_l);
		if(empty($res_l) && ($types == 'crm_leads' || $types == 'crm_customer')){
			// 构建查询
			$query = $dataModels->field('mobile')
				->where($structureWhere)->where($where)
			    ->whereRaw("MATCH(mobile) AGAINST(:mobile IN BOOLEAN MODE)")
			    ->bind(['mobile' => $matchmobile]);
			
			// 执行查询
			$res_l = $query->find();
		}

全文索引
ALTER TABLE xccrm_crm_customer ADD FULLTEXT INDEX fulltext_article(mobile);