sql: filter string results by uppercased

Question

So I have a SQL query that returns a name and a id per row. The problem is that the name values, some are upper-cased and others are lower-cased. The query in question is:

SELECT DISTINCT ttd.name, ttd.tid
FROM taxonomy_term_data ttd
INNER JOIN field_data_field_xxxxxx_paraules_clau fdfspc ON ttd.tid = fdfspc.field_xxxxxx_paraules_clau_tid
ORDER BY ttd.name

the result is something like:

alfred | 1
ALBERT | 2
MARIA  | 3
Sam    | 4

What I want is a WHERE clause to only get the rows with upper-cased name like:

WHERE ttd.name IS UPPERCASED

I have been searching on internet, but I only get results about capitalize or uppercased text.

Possible duplicate of How to check for uppercase letters in MySQL? — Robert H
– Robert H, Commented Feb 27, 2018 at 16:29
WHERE ttd.name > 'A' might help regex should work even better WHERE ttd.name REGEXP '^[A-Z]+' — Raymond Nijland
– Raymond Nijland, Commented Feb 27, 2018 at 16:30
Possible duplicate of Select ALL fields that contains only UPPERCASE letters — isaace
– isaace, Commented Feb 27, 2018 at 16:31
There are some results that are Capitalized (first letter upercased), so the Raymond solution doesn't work — Albert Lazaro de Lara
– Albert Lazaro de Lara, Commented Feb 27, 2018 at 16:34

louffi · Accepted Answer · 2018-02-27 16:42:12Z

0

This can be done with the BINARY comparison and UPPER() in mysql

WHERE ttd.name = BINARY UPPER(ttd.name)

source : How to find all upper case strings in a MySQL table?

answered Feb 27, 2018 at 16:42

louffi

2155 silver badges20 bronze badges

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

1 Comment

Albert Lazaro de Lara Over a year ago

It worked! I tried without the binary and nothing. But like this works fine.

Collectives™ on Stack Overflow

sql: filter string results by uppercased

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related