mysql - 如何使用mysql查询按字母表中的名称排序

Question

我的相册按 id 排序，现在我想只显示相册只有 B 字母。

我的旧查询

$valueql_select="SELECT DISTINCT (i.gallery_album_id) FROM mov_gallery_album AS a, mov_gallery_images AS i WHERE a.gallery_album_id = i.gallery_album_id AND a.gallery_cat_id =".$_GET['cat']." ORDER BY gallery_id desc";

我尝试使用 LIKE

$valueql_select="SELECT DISTINCT (i.gallery_album_id) FROM mov_gallery_album AS a, mov_gallery_images AS i WHERE a.gallery_album_id = i.gallery_album_id AND a.gallery_cat_id =".$_GET['cat']." ORDER BY name LIKE 'b%'";

但是上面的查询不起作用。

Answer 1

将条件放在 WHERE 子句中:

$valueql_select="SELECT DISTINCT i.gallery_album_id
                 FROM mov_gallery_album AS a
                 JOIN mov_gallery_images AS i
                 ON a.gallery_album_id = i.gallery_album_id
                 WHERE a.gallery_cat_id = '42'
                 AND name LIKE 'b%'
                 ORDER BY name";

您还有一个 SQL 注入(inject)漏洞。 不要将值连接到您的 SQL 字符串中。特别是当它们直接来自用户输入而没有任何验证时。

相关

• How can I prevent SQL injection in PHP?