Hi,
Need Help regarding a query.
I want to search all empName from emp table whose name 3rd letter is "s"
jacob21
0
Posting Whiz in Training
Recommended Answers
Jump to PostHow much of your query have you done so far? What progress have you already made?
You could whip something up using single-character wildcards. There might be a better way to achieve this, …
Jump to PostDid your homework get a good grade after these guys helped you?
All 6 Replies
Assembly Guy
72
Posting Whiz
How much of your query have you done so far? What progress have you already made?
You could whip something up using single-character wildcards. There might be a better way to achieve this, but the wildcard method will certainly work.
jacob21
0
Posting Whiz in Training
Hi,
SELECT * from emp WHERE name LIKE "%S%"
I am not sure about "%S%"
Assembly Guy
72
Posting Whiz
That's almost it, except % will match 0 or more characters, which isn't quite what you want. Your current query will match things like:
- asdf
- aaa239vjsdio4
- 123s123
What you could try using is a combination of the % and _ operators
jacob21
0
Posting Whiz in Training
SELECT * FROM user WHERE username LIKE '%__m%'
Is above is right.Plz Suggest!!!
Assembly Guy
72
Posting Whiz
Almost, just drop that first % sign. You want to match:
Any single character, any single character, "s", any amount of characters
So it'd become '__s%'
drjohn
56
Posting Pro in Training
Did your homework get a good grade after these guys helped you?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.