How to find rows that have a value that contains a lowercase letter

Question

I m looking for an SQL query that gives me all rows where ColumnX contains any lowercase letter  e g   1234aaaa5789    Same for uppercase

User · Answer

In Posgresql you could use    For example you could search for all rows that have col a with any letter in lowercase  select   from your table where col a   a-z     You could modify the Regex expression according your needs   Regards

User · Answer

--For Sql  SELECT   FROM tablename WHERE tablecolumnname LIKE    a-z

User · Answer

SELECT   FROM my table WHERE my column    my string  COLLATE Latin1 General CS AS   This would make a case sensitive search     EDIT  As stated in kouton s comment here and tormuto s comment here whosoever faces problem with the below collation  COLLATE Latin1 General CS AS   should first check the default collation for their SQL server  their respective database and the column in question  and pass in the default collation with the query expression  List of collations can be found here

User · Answer

I m not an expert on MySQL I would suggest you look at REGEXP   SELECT   FROM MyTable WHERE ColumnX REGEXP    a-z

User · Answer

mysql gt  SELECT  1234aaaa578  REGEXP    a-z

User · Answer

This is how I did it for utf8 encoded table and utf8 unicode ci column  which doesn t seem to have been posted exactly   SELECT   FROM table WHERE UPPER column     BINARY column

User · Answer

Logically speaking Rohit s solution should have worked  but it didn t  I think SQL Management Studio messed up when trying to optimize this   But by modifying the string before comparing them I was able to get the right results   This worked for me   SELECT  ExternalId  FROM  EquipmentSerialsMaster  where LOWER  0   ExternalId   COLLATE Latin1 General CS AS     0   ExternalId

User · Answer

for search all rows in lowercase  SELECT   FROM Test WHERE col1  LIKE    abcdefghijklmnopqrstuvwxyz    collate Latin1 General CS AS   Thanks Manesh Joseph

User · Answer

SELECT   FROM my table  WHERE UPPER some field     some field   This should work with funny characters like                 You might need to use a language-specific  utf-8 collation for the table

User · Answer

I ve done something like this to find out the lower cases    SELECT   FROM YourTable   where BINARY CHECKSUM lower ColumnName     BINARY CHECKSUM ColumnName

User · Answer

SELECT   FROM Yourtable  WHERE UPPER  column NAME   COLLATE Latin1 General CS AS    Column NAME

User · Answer

I have to add BINARY to the ColumnX  to get result as case sensitive  SELECT   FROM MyTable WHERE BINARY ColumnX  REGEXP    a-z

User · Answer

IN MS SQL server use the COLLATE clause   SELECT Column1 FROM Table1 WHERE Column1 COLLATE Latin1 General CS AS    casesearch    Adding COLLATE Latin1 General CS AS makes the search case sensitive   Default Collation of the SQL Server installation SQL Latin1 General CP1 CI AS is not case sensitive   To change the collation of the any column for any table permanently run following query   ALTER TABLE Table1 ALTER COLUMN Column1 VARCHAR 20  COLLATE Latin1 General CS AS   To know the collation of the column for any table run following Stored Procedure   EXEC sp help DatabaseName   Source   SQL SERVER     Collate     Case Sensitive SQL Query Search

[sql] How to find rows that have a value that contains a lowercase letter

Examples related to sql

Examples related to mysql