Find longest string in a column

Databases
1

I had been looking for ways to select the longest string record of a column in a database, may I know is there a sql query for it ?
such as looking up the person that has the longest name
“name”
John
Abdullah Ahmad Badawi
marry
…
…

Thank you.

2

select name from daTable
where length(name) =
( select max(length(name)) from daTable )

3

Thank you, that’s good one, but how about the record that has the most number of words ? I am referring to MYSQL manual now, but still can’t find a solution for this. Thank you.

4

here’s an idea

compare LENGTH(name) and LENGTH(REPLACE(name,’ ‘,’'))

the difference is the number of spaces removed

find the max of that

:slight_smile:

5

I was wondering why you all have such a good idea, does this idea comes naturally or because you have experienced it before from somewhere else ? I would like to improve my logic skills. Got any advice for me ? Thanks.

6

it comes from practice, practice, practice

:slight_smile:

7

Just in case if anyone like to know the solution,
SELECT lemma FROM word WHERE (LENGTH(lemma)-LENGTH(REPLACE(lemma,’ ‘,’‘)))=(SELECT MAX(LENGTH(lemma)-LENGTH(REPLACE(lemma,’ ‘,’'))) FROM word);

8

very nice :slight_smile:

9

Yeah, you are right, it comes from practice, practice, practice, practice, and even more practice. :slight_smile:

10

wanna know a really good way to practice?

start answering questions on database forums

:slight_smile:

11

Yeah…Thanks, I would allowed some of my time to do it even I am very busy with my own stuff.