HTML In Concatenation in MySQL

Question

SELECT
    EB.first_name AS FNAME,
    EB.emp_id AS EID,
    CONCAT(EB.first_name,' ',EB.mid_name,' ',EB.last_name) AS FULLNAME,
    EB.id AS ID,
    ESAL.dept_id AS DEPT_ID,
    DATE_FORMAT(EB.dob,'%D %b %y') AS DOB,
    EB.email_per AS EPER,
    EB.mobile_per AS MOBPER,
    EB.father_name AS FATHER,
    EB.mother_name AS MOTHER,
    EB.sex AS SEX,
    EB.email_office AS EOF,
    EB.mobile_office AS MOBO,
    EB.blood_group AS BG,
    CONCAT(EB.id_type,' : ',EB.id_no) AS ID,
    CONCAT(EB.present_addr,'<br>',EB.present_city_id,'<br>',EB.present_state_id) AS PRA
FROM mtc_employee_master EB
LEFT JOIN mtc_employee_education_master EE  ON EE.emp_tbl_id = EB.id
LEFT JOIN mtc_employee_experience_master EEXP ON EEXP.emp_tbl_id = EB.id
LEFT JOIN mtc_employee_salary_master ESAL ON ESAL.emp_tbl_id = EB.id WHERE EB.id=".$data['id']."

What I am trying to do to embed HTML content in concat of MySQL..is it possible?? Please help..

cn0047 · Accepted Answer · 2015-04-27 10:12:57Z

1

Yes it's possible, even if it not the best solution...

SELECT CONCAT('<p>', now(), '</p>') as html;
+----------------------------+
| html                       |
+----------------------------+
| <p>2015-04-27 13:12:33</p> |
+----------------------------+

and you have already done this in:
CONCAT(EB.present_addr,'<br>',EB.present_city_id,'<br>',EB.present_state_id,)
but you should delete comma: CONCAT(EB.present_addr,'<br>',EB.present_city_id,'<br>',EB.present_state_id)

answered Apr 27, 2015 at 10:12

cn0047

17.2k7 gold badges61 silver badges75 bronze badges

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

Collectives™ on Stack Overflow

HTML In Concatenation in MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related