我必须在单列中的名称中查找数值 [英] I have to find numeric values in a name in single column

问题描述

我有桌子像

ID名称

1 J0hnson

2 sachin

3 tesera tere8a



我要结果如

ID Name

1 j0hnson

3 tesera tere8a

任何人都可以帮我，给我发询问题



我尝试了什么：



我还没有尝试过请帮助我

I have table like
ID Name
1 J0hnson
2 sachin
3 tesera tere8a

I want result like
ID Name
1 j0hnson
3 tesera tere8a
can anyone help me,send me the query

What I have tried:

I haven't tried please help me from this

推荐答案

你将成为一个非常有帮助的吸血鬼：最后三个你的问题 - 都是在24小时内发布的 - 都是相关的主题，而你已经拥有的解决方案可以用来解决其他问题。



我们是不是在这里为你做功课代替你为自己思考：这是有原因的。它就是为了让你思考你被告知的事情，并试着理解它。它也在那里，以便您的导师可以识别您身体虚弱的区域，并将更多的注意力集中在补救措施上。



亲自尝试，你可能会发现它不是和你想的一样困难！



如果遇到具体问题，请询问相关问题，我们会尽力提供帮助。但我们不打算为你做这一切！

You are getting to be quite a help vampire: the last three of your questions - all posted in the same 24 hours - are on a related subject, and the solutions you already have can be adapted to solve the others.

We are not here to do your homework for you in lieu of you thinking for yourself: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!

If you meet a specific problem, then please ask about that and we will do our best to help. But we aren't going to do it all for you!

这篇关于我必须在单列中的名称中查找数值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！