CAST() is useful for sorting ENUM columns in lexical order. : CAST : Cast Functions Operators MySQL TUTORIALS

CAST() is useful for sorting ENUM columns in lexical order.

Related Scripts with Example Source Code in same category :
• CAST(expr AS type), CONVERT(expr,type), CONVERT(expr USING transcoding_name)
• Converting the string 'abc' in the default character set to the corresponding string in the utf8 character set
• Convert blob column to char type
• The cast functions are useful when you want to create a column with a specific type in a CREATE ... SELECT statement
• CAST() also changes the result if you use it as part of a more complex expression such as CONCAT('Date
• SELECT CAST(1 AS UNSIGNED) - 2.0;

Leave a Comment / Note

Name (required)

email (will not be published) (required)

Website

Vérification Refresh		Enter code
Verification is used to prevent unwanted posts (spam). .