use mysql substr and mysql concat on database setup Folgen

0
Avatar
candra

Dear BarTender,

I want to use mysql substr and mysql concat on database setup>>SQL statement and it do not work

this is my code:

SELECT `Categori`, `Brand`, `Type`, SUBSTRING(`Code`,5) FROM `product`

SELECT `Categori`, `Brand`, `Type`, CONCAT(`Code`, '-', `Date`)FROM `product`

How to implement this Query?

Regards,

Candra

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.