... use a substring-extraction function. To combine strings, use CONCAT( ) . ... mysql> SELECT name, LEFT(name,2), MID(name,3,1), RIGHT(name,3) FROM metal; ...
確定! 回上一頁