MySQL 8.0

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

select version();


version()


8.0.22


create table products (product_id int, product_name varchar(10), pack_size varchar(10), price int(10), price_change varchar(100));
insert into products values(1,'Eggs','1*3','1','1'),(2,'Milk',3*3,'2','2'),(3,'Fish','4 Boxes','4','4');
select * from products


product_id
product_name
pack_size
price
price_change


1
Eggs
1*3
1
1

2
Milk
9
2
2

3
Fish
4 Boxes
4
4