在特定数据中获取字母位置案例敏感
在db(somename)中,在列中的表(wrorker)中(first_name)有一个字段(agenname)
我想知道在该特定的“ agenname”中的“ A”的位置(case敏感。6。不是1)
看到了一些带有二进制,位置,strindex,Colutate等的一般示例,
但是它们在所有高水平的地方。
我想学习如何在特定字段上使用它们。
例如,也许在句子中的某个地方 -
select first_name from worker where first_name = AGenName
thnx寻求帮助
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
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
从一个朋友那里得到了这个。
简单简单:
(在她的db firstName ='amitabh'上,所以..)
got this from a friend.
Simple and easy:
(on her DB firstName = 'Amitabh', so..)