Inayotumika kwenye SQL LCASE()

Fomu ya LCASE()

Fomu ya LCASE() inasaidia kubadilisha thamani ya kina kwa kina chakuu.

Mwongozo wa SQL LCASE()

SELECT LCASE(column_name) FROM table_name

Mfano wa SQL LCASE()

Ninamosha tablica hii ya "Persons":

Id LastName FirstName Adress City
1 Adams John Oxford Street London
2 Bush George Fifth Avenue New York
3 Carter Thomas Changan Street Beijing

Hivi sasa, tunataka kuwaona kina ya "LastName" na "FirstName", kisha kutumia "LastName" kwa kubadilisha katika kina chakuu.

Tumetumia maandiko ya SQL iliyofuata:

SELECT LCASE(LastName) as LastName,FirstName FROM Persons

Matokeo ya msingi inaonekana kama hii:

LastName FirstName
adams John
bush George
carter Thomas