1054:Unbekannte Spalte ?a.first_letter“ in ?where-Klausel“ a.pic_url AS vod_pic_url, a.definition AS vod_definition, a.movie_type AS vod_movie_type, b.price AS vod_price, c.pay_flag AS vod_pay_flag FROM vod AS a LEFT JOIN vod_price AS b ON b.vod_id = a.id LEFT JOIN vod_pay_log AS c ON c.pay_vod_id = a.id AND c.checkin_id = ''WHERE a.status = 1 AND a.classid =1 AND a.first_letter like 'A%' ORDER BY a.sort, a.id DESC</h1> ;
3
0
0
歡迎選擇我的課程，讓我們一起見證您的進(jìn)步~~
你可以試下把a.first_letter放到查詢字段里面,記得好像5.7版本之后的sql,查詢條件字段必須在select里面有查出來.也可以通過修改my.cnf避免這個.
![[Web-Frontend] Node.js-Schnellstart](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
