MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE x_table (name VARCHAR(100), currencyType  VARCHAR(100));
INSERT INTO x_table VALUES ('Rupee', '5X34'), ('Dollar', '3X34$'), ('Yen', '7X57');

Records: 3  Duplicates: 0  Warnings: 0


select name, SUBSTRING_INDEX(currencyType, 'X', 1) as count,SUBSTRING_INDEX(currencyType, 'X', 2) as type   from x_table


name
count
type


Rupee
5
5X34

Dollar
3
3X34$

Yen
7
7X57