SELECT SUBSTRING(`firstname`,1,2) as 'firstname',SUBSTRING (`las

how to retrieve from database..... this format (PRMRMDU402).
firstname= prabhu, lastname=kumar, city=madurai,
pincode=624402....

i want first name first two letters and last name last two
letters ... city first two letters ... pin code last three
letters....

Question Posted / ajit

2 Answers
4381 Views
I also Faced
E-Mail Answers

Answer Posted / ajit

SELECT SUBSTRING(`firstname`,1,2) as 'firstname',SUBSTRING
(`lastname`,-2) as 'lastname',SUBSTRING(`city`,1,2) as
'city',SUBSTRING(`pincode`,-3) as 'pincode' FROM
`user_info` WHERE 1

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is variable give example?

1049

What is self in php?

1128

Is python easier than php?

988

What is php and how do you use it?

992

How do I know my xampp version?

987

What is the function of trim?

921

What is the purpose of php?

951

What is the use of callback in php?

982

Which php framework is best?

967

What is array and function?

1035

What is variable function php?

1041

Is jquery better than javascript?

964

What is xss and csrf?

923

Is apache needed for php?

899

What are Routines?

2218