mysql - SQL - 子字符串并同时选择 *

Question

我需要做一个列的子字符串，而且在我做选择时还拉出所有列。以下是我尝试使用的代码，但它无法正常运行:

SELECT SUBSTRING(column_c, 1, 11) AS dateMoved, *
                FROM prostock_movement_header 
                WHERE column_a = '74' 
                AND column_b = '1372' 
                AND dateMoved = '2019-02-23'

如何在同一语句中执行 SELECT * 和 SUBSTRING() AS ALIAS，以便检索所有列以及别名列。

或者是从表中按名称手动选择每隔一列的唯一方法吗？

谢谢

Answer 1

只是改变选择的顺序

SELECT *,SUBSTRING(column_c, 1, 11) AS dateMoved
                FROM prostock_movement_header 
                WHERE column_a = '74' 
                AND column_b = '1372' 
                AND SUBSTRING(column_c, 1, 11) = '2019-02-23'