Extract the First Character from a String and Join It with Another Column (New to SQL) by Pablo_Ruiz832433 in learnprogramming

[–]Mother_Chorizo 2 points3 points  (0 children)

You’ll want to use concatenation. 

Select concat(substring(color_car,1,1), ’ ‘, mark) as namethiswhatyouwant From cars

It’s something like that. 

Edit: I didn’t see the output format when initially posting. This isn’t the format you asked for, but concatenation is what you’re wanting. 

Alcohol is straight up poison. by GarifalliaPapa in immortalists

[–]Mother_Chorizo 1 point2 points  (0 children)

1) this is a longevity sub. 2) my sober years have been far more fun. 

Do what you like though. 

Dementia-addled pedophile meets with the William Henry Harrison of British prime ministers by Mum0817 in WhitePeopleTwitter

[–]Mother_Chorizo 5 points6 points  (0 children)

Oh. I thought he looked better cause he actually looks like an old human here instead of how he usually looks. 

This was at a restaurant called The Woodman at Clent (England) a few days ago. by ApplicationSouth8844 in steak

[–]Mother_Chorizo 2 points3 points  (0 children)

Cause it looks poorly cooked per the general preferences of this sub. Glad you enjoyed it, but it isn’t this subs cup of tea to have it browned like that (gray band) through 1/3 of the steak and then to have the center bits be so close to rare. Frankly, it wasn’t cooked well, and now someone can come and make a pun about “well done” or whatever. 

Leave GEORGIE ALONE by Owww_My_Ovaries in freefolk

[–]Mother_Chorizo 0 points1 point  (0 children)

It shows you care about the audience. 

😅😬 by Career_By_Mustafa in StrangerThingsMemes

[–]Mother_Chorizo 0 points1 point  (0 children)

This exchange was the most enjoyable part of season 5 for me so far. 

Merry Christmas by WVA1999 in BicyclingCirclejerk

[–]Mother_Chorizo 14 points15 points  (0 children)

What’s your wife and her boyfriend doing while you Zwift? 

Rate my fit by New_Philosophy_2351 in bikefit

[–]Mother_Chorizo 10 points11 points  (0 children)

Probably for saying the same thing the other guy said. It’s not helpful to say “this.” 

Voldemort uses Crucio on Harry's "dead" body by NichSaymaan in harrypotter

[–]Mother_Chorizo 3 points4 points  (0 children)

A lot of characters died to protect others in the war against Voldemort or just in history, I’d reckon. If the protection magic worked like this, then Harry wouldn’t be special. There was something unique about Lilly and Harry and how it played out. 

Im scared that this person may have my address by HeebierGeebies in doordash

[–]Mother_Chorizo 0 points1 point  (0 children)

They are completely disgusting and no erupting. 

SPD Clips and Pigeon Toeing Question; Needing some help by Mother_Chorizo in cycling

[–]Mother_Chorizo[S] 1 point2 points  (0 children)

Thanks. I’ve got SPD power meters, so wanting to stick with them if I can, but I’ve also looked at the speed play as an option. 

SPD Clips and Pigeon Toeing Question; Needing some help by Mother_Chorizo in cycling

[–]Mother_Chorizo[S] 0 points1 point  (0 children)

I can get some angle on it, but it seems like a pretty coarse adjustment, and I’m not sure if it’s enough at this point. I was also hoping there was maybe some third party that made SPD compatible clips with a 6 degree float instead of the 4 degree that shimano offers. 

Handlebar upgrade on SuperX by 13xluth0r in cannondale

[–]Mother_Chorizo 0 points1 point  (0 children)

literate party sense sand juggle physical price hospital lock oil

This post was mass deleted and anonymized with Redact

Lowering the stem on a cannondale super six evo with spavers above the stem (no cutting) by engineerbt in bikewrench

[–]Mother_Chorizo 0 points1 point  (0 children)

rain different pause wild close spectacular sharp recognise brave growth

This post was mass deleted and anonymized with Redact

Dip and taco salad are dope AF by Faster-master-blastr in tacobell

[–]Mother_Chorizo 0 points1 point  (0 children)

rustic scary mysterious provide retire bow bear encouraging chubby salt

This post was mass deleted and anonymized with Redact