| |

VerySource

 Forgot password?
 Register
Search
View: 21|Reply: 3

Newbie question: Show employee names without 'R'. Thank you all for your help!

[Copy link]

1

Threads

3

Posts

4

Credits

Newbie

Rank: 1

Credits
4

 China

Post time: 2020-3-14 19:00:01
| Show all posts |Read mode
As the title, I checked a lot of character functions such as substr but they are not flexible enough to be arbitrary string length. I hope the experts can answer, thank you!
Reply

Use magic Report

1

Threads

3

Posts

4

Credits

Newbie

Rank: 1

Credits
4

 China

 Author| Post time: 2020-6-12 20:00:01
| Show all posts
Do you like it first? Does anyone help?
Reply

Use magic Report

0

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-6-18 19:00:01
| Show all posts
select * from employees where name not like'%r%'
Reply

Use magic Report

1

Threads

3

Posts

4

Credits

Newbie

Rank: 1

Credits
4

 China

 Author| Post time: 2020-6-23 12:30:01
| Show all posts
Haha, I actually regret such a simple question after I post it. I always think about character functions and the like, and forget even the most basic fuzzy queries. Anyway, thanks. Master!
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list