MySQL Forums
Forum List  »  Views

how to create a field from another field
Posted by: andy susanto
Date: August 22, 2010 03:17AM

hai,

i have a field that contain like this, every line contain a new line:
First Record :
B 9143 KJ
ESPASS
KM. 81.107FZ

Second Record :
B 2499 SN
PRESTIGE
KM. 204.954
TL/PN

is that possible to split the data into three additional field with a view method.

i would like to use regular expression. this is my syntax.

SELECT simaster_desc FROM simaster WHERE simaster_desc REGEXP 'KM.' '[0-9]*';

but the result of that field always show the first line.

Regards,

Andy Susanto

Options: ReplyQuote


Subject
Views
Written By
Posted
how to create a field from another field
2509
August 22, 2010 03:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.