Combine Strings – CONCAT | Rex's Personal Site

SELECT a.`id`, a.`event_id`, a.`first_name`, a.`last_name`, a.`mobile`, 
a.`appointment_time`, a.`deleted`, a.`updated_time`, 
<span style="color:#ff0000;">concat</span>(b.`title`, &#39; &#39;, b.`first_name`, &#39; &#39;, b.`last_name`) as `doctor_name`
FROM `customers` as a
join `doctors` as b on b.`id` = a.`doctor_id`
WHERE `appointment_time` between &#39;2012-12-1&#39; and &#39;2013-1-1&#39;

SELECT a.`id`, a.`event_id`, a.`first_name`, a.`last_name`, a.`mobile`,

a.`appointment_time`, a.`deleted`, a.`updated_time`,

<span style="color:#ff0000;">concat</span>(b.`title`, ' ', b.`first_name`, ' ', b.`last_name`) as `doctor_name`

FROM `customers` as a

join `doctors` as b on b.`id` = a.`doctor_id`

WHERE `appointment_time` between '2012-12-1' and '2013-1-1'

2 thoughts on “Combine Strings – CONCAT”

quick loans no credit checks 03/21/2013 at 10:40 pm

And verify which you’ve given them the right quantity so they can enter touch along with you quick loans no credit checks that is a bit more interest when compared to a mortgage, car loans, school loan, or personal loan.

These coupons 03/22/2013 at 4:22 am

This is really attention-grabbing, You are a
very skilled blogger. I have joined your rss feed and look ahead
to seeking more of your magnificent post. Also,
I have shared your web site in my social networks

Comments are closed.

M	T	W	T	F	S	S
					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30
31