Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

SQL gets the first letter of the field string

2025-03-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Have Chinese and English, get Chinese initials information.

SELECT person_name_cn

ELT (INTERVAL (CONV (HEX (LEFT (CONVERT (person_name_cn USING gbk), 1)), 1610)

0xB0A1,0xB0C5,0xB2C1,0xB4EE,0xB6EA,0xB7A2,0xB8C1,0xB9FE,0xBBF7

0xBFA6,0xC0AC,0xC2E8,0xC4C3,0xC5B6,0xC5BE,0xC6DA,0xC8BB,0xC8F6

0xCBFAB0xCDDAdicol 0xCEF4rec 0xD1B9pr 0xD4D1)

'Aphrodite,' Bobby,''Bai,' 'Che,' 'Equ,' Fong,''Gai,' 'Gai,' 'Jai,' Kang,''Lai,' Lai, 'and',',

'Qothers, Z',' AS PY,''

FROM person WHERE LEFT (person_name_cn,1) NOT IN ('Achilles Permian, Bengal, Centraly, Dharma, Fideli, Geddales, Gracias, Hutchison, Hutchison, Kleptoe, Kleptocrys, Lhasa, Mumpies, Oppies, P'

'Qothers, pencils, pundits, squares, squares, pageants, winters, winters, Xlies, pageants, yams, Z')

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report