Andrew Braithwaite wrote:
Is there any way to get MySQL to return the results of this query with
the 'fieldname' in the order listed in the in() bit?
select fieldname from tablename where fieldname in
('B4079','B4076','B4069','B4041','A4710','58282','58220','56751','56728'
,'45003','09234','04200',
MAIL PROTECTED]
> Sent: 11 May 2005 12:53
> To: mysql@lists.mysql.com
> Subject: RE: Remove 1st 3 Chars
>
> Hello,
>
> Is there any way to get MySQL to return the results of this query with
> the 'fieldname' in the order listed in the in() bit?
>
> select fie
Hi !
First, could do avoir hijacking somebody else thread ?
Andrew Braithwaite wrote:
Hello,
Is there any way to get MySQL to return the results of this query with
the 'fieldname' in the order listed in the in() bit?
select fieldname from tablename where fieldname in
('B4079','B4076','B4069','B4041
Hello,
Is there any way to get MySQL to return the results of this query with
the 'fieldname' in the order listed in the in() bit?
select fieldname from tablename where fieldname in
('B4079','B4076','B4069','B4041','A4710','58282','58220','56751','56728'
,'45003','09234','04200','04035','04026');
Hi Shaun,
I guess you could try something like:
UPDATE table SET col = RIGHT(col, LENGTH(col) - 3 ) WHERE ...
/Johan
shaun thornburgh wrote:
Hi,
is it possible to alter fields in a column by removing the first three
characters?
i.e. change 100123456789 to 123456789
Thanks for your help
--
MySQ
Look at the substring example here
http://dev.mysql.com/doc/mysql/en/string-functions.html
Regards,
Reinhart Viane
-Oorspronkelijk bericht-
Van: shaun thornburgh [mailto:[EMAIL PROTECTED]
Verzonden: woensdag 11 mei 2005 13:30
Aan: mysql@lists.mysql.com
Onderwerp: Remove 1st 3 Chars
Hi
Hi,
is it possible to alter fields in a column by removing the first three
characters?
i.e. change 100123456789 to 123456789
Thanks for your help
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]