Search code examples
mysqlcase-sensitive

get letter location case sensitive in a specific data

in a db (someName), in a table (worker) in a column (first_name) there is a field (AGenName)
I would like to know the location of 'a' in that specific 'AGenName' (case sensitive. 6. not 1)

Saw some general examples with binary, position, strIndex, collate etc,
but they where all high Level.
I would like to learn how to use them on a -specific- field.
like, perhaps somewhere in a sentence like -

select first_name from worker where first_name = AGenName

Thnx for the help

Solution

  • got this from a friend. Simple and easy: (on her DB firstName = 'Amitabh', so..)

    select instr(binary first_name, binary'a') from worker where firstName = 'Amitabh';