How is “SELECT *” read in English? [closed]

Question

The other day, a friend told me that in USA, they pronounce SQL like squel, not es-qu-el. I was surprised. I was wondering how "SELECT *" is read/pronounced while talking.

• select star?
• select asterisks?
• select all?

Answer 1

I live in the US and almost always hear it pronounced select star

And normally I use sequel instead of es-qu-el because it has fewer syllables and seems easier to say

Answer 2

SQL was originally called SEQUEL, which is why many people say it that way.

However, ANSI declared that it be called SQL (es-q-el) at some point in the 80's (it was already spelled SQL at that time.) (at the first standardisation conference in 1986.)

Personally, since the creators of SEQUEL called it that way, I think it's more respectful to call it by that name (Ray Boyce, died of a brain aneurism before SQL was standardised), as opposed to some committee designation. (Not to mention the vast majority of people who were using SQL back then called it SEQUEL, so that's it's original organic language usage.)

However, there is zero controversy on how you say SELECT * I suppose select all is most useful, in terms of communication, but there's no canonically correct way, and you will hear people say select star pretty often, select asterisk is poor rhythmically, and conveys no meaning, so it's unlikely anyone would ever use that phrasing. Because, you know, it sounds stupid.

Update:

I misremembered the cause of death of Ray Boyce, brain aneurism, (one of SEQUEL's creators) - not a car accident.

Answer 3

The voice in my head (well, one of them) reads that to me as 'select all' as I read it, so that's how I pronounce it.

I think any of the three would convey what you mean, though. I really don't think it matters so long as you are understood.

Answer 4

When you say English, I presume you mean UK?

If so then:

SQL is pronounced mostly as squel , sometimes it is referred to as es-qu-el

"select star" is usually what I hear in the UK.

Answer 5

At one time I did NC installations over a large number of computers and operating systems. One of the things that I learned is to feel out the local buzz words and speak to the shop in their local jargon. i.e. A Univac "file" is similar to a PC "folder".
If you're speaking to the masses then the most used is the best.
As an example:

A Poem For Computer Geeks 
< > ! * ' ' #
^ " ` $ $ -
! * = @ $ _
% * < > ~ #4
& [ ] . . /
| { , , SYSTEM HALTED

A Translation for the Mundanes
Waka waka bang splat tick tick hash
Caret quote back-tick dollar dollar dash
Bang splat equals at dollar underscore
Percent splat waka waka tilde number four
Ampersand bracket bracket dot dot slash
Vertical bar curly brace comma comma crash

This is a good example of how the buzz words get going and change over time. And yes I ran into a bunch of them when I was doing installations.
(Besides that it is a poem with both meter and rhyme.)

Answer 6

I am from US and I call it es-que-el but I have heard it called sequel many times, and even knowing the history I still dislike it.

I also aways call it "select star".

"Select all" can be misleading if you tell someone to type select all they might actually type "select all" and "select asterisk" is a mouthful.

Answer 7

I might be in the minority, but I read SELECT * as "select everything".

Then again, I also pronounce SQL as "sequel" (except in the case of PostgreSQL, of course). What can I say, I was weaned on ASP and Microsoft SQL Server.

Answer 8

I live in the USA, in the Pacific Northwest, and I never hear Es-Que-El here.

I initially started out saying Es-Que-El, and every time I heard someone say Sequel it hurt my brain, but since most (if not all) my peers were saying Sequel, including the guys in our database admin shop, I gave up and went with the flow. Nowadays, it is hearing Es-Que-El that hurts my brain.

Additionally, since we use the Microsoft SQL Server product, and apparently nobody says "Es-Que-El Server" (sounds horrible) but all one hears is "Sequel Server".

And in our organization, we say "SELECT Star" for SELECT *.

Answer 9

I say "SELECT star" and "SEQUEL".

Answer 10

IMHO, "SEQUEL" really sounds kinky to me, so I say it as "Es-Que-El".

I say "SELECT *" as "select all".

Both of my preferred pronunciation just sounds simple and cool to me.

Answer 11

There is a contingent of people (they tend, in my experience to have long grey beards) who refer to the "*" character as a "splat".

They also tend to call "!" "bang" and "#" "sharp".

When working with the greybeard I used to work with, hearing "select splat from" wasn't uncommon.

Answer 12

Select star. And sea quell because it sounds more English than ess-queue-elle (which sounds better with an American accent). My company is called char star as in char*. Star just sounds nice.

We had one of those old people at college (although it was long enough ago that I am now technically old). SQL was a contraction of SEQueL which was Structured English QUEry Language. I've also heard Squirrel used.

As an aside, # as sharp is fine by me as is hash.