php - codeigniter中的SQL查询错误

Question

我在 phpmyadmin 中尝试了以下代码，但收到语法错误:

select * from `reviews_az` 
left join `restaurants_az` on `reviews_az`.`restaurant_id` = `restaurants_az`.`id`  
where `source` LIKE %YELP% order by `reviews_az`.`id` desc limit 6);

这是错误日志:

MySQL 说:文档

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%YELP% order by `reviews_az`.`id` desc limit 6)' at line 1

Answer 1

您在 like 中缺少单引号。

正确查询:

在reviews_az.restaurant_id =restaurants_az.id上从reviews_az中选择*左加入restaurants_az，其中source LIKE '%YELP%' order byreviews_az.id desc limit 6