Help me for converting give ms access query into MySQL query?

Question

I am new for mysql, my real data as Mr. & Mrs. Yehuda Sarale Adelist:580 Crown St. #311 11213 after triggering ms-access query i got Mr. & Mrs. Yehuda Sarale Adelist. Ms-Access query define below:

SELECT 
CopyExcelHere.Field1, 
Replace([Field2],":",Chr$(13) & Chr$(10)) AS F2, 
Replace([Field3],":",Chr$(13) & Chr$(10)) AS Expr1
FROM CopyExcelHere;

I want convert this MS query into mysql query,to get a result Mr. & Mrs. Yehuda Sarale Adelist. any help will be appricated.

Thanks

ajreal · Accepted Answer · 2011-01-05 08:43:02Z

2

maybe this should work

select 
  CopyExcelHere.Field1,
  replace(Field2, ':', "\r\n") as F2,
  replace(Field3, ':', "\r\n") as Expr1,
from 
   CopyExcelHere;

answered Jan 5, 2011 at 8:43

ajreal

47.4k11 gold badges97 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Sameek Mishra Over a year ago

Thanks for reply.my real data as

Sameek Mishra Over a year ago

my real data as Mr. & Mrs. Yehuda Sarale Adelist:580 Crown St. #311 11213 after triggering ms-access query i got Mr. & Mrs. Yehuda Sarale Adelist. according to your query i get Mr. & Mrs. Yehuda Sarale Adelist 580 Crown St. #311 11213. please help me to find mysql query that gives me the following result Mr. & Mrs. Yehuda Sarale Adelist

ajreal Over a year ago

@sam - You need to update your question to indicate what is inside Field1, Field2, Field3 separately

Collectives™ on Stack Overflow

Help me for converting give ms access query into MySQL query?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related