Remove Hyphens from MySQL UUID: Quick Guide

1 year ago
Isabella Edwards
1 minute

In MySQL, the standard format for UUID includes dashes, such as “550e8400-e29b-41d4-a716-446655440000”. If you want to remove the dashes from the UUID, you can use the built-in REPLACE() function in MySQL.

Below is an example:

SELECT REPLACE(uuid_column, '-', '') AS uuid_without_dash
FROM your_table;

The uuid_column here is the name of the column containing UUIDs, and your_table is the name of the table containing UUIDs. This query will return a UUID without dashes.

bannerAds