Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SELECT rows having specific SUBSTRING

Status
Not open for further replies.
Delphard

Delphard

Programmer
Jul 22, 2004
144
RS
Table with field "SPEC_STRING" (VARCHAR(15)). How to SELECT rows having substring '111222' at position 9 (for example: strings like 'abcdefghi111222' or '000000000111222')?
 
Sort by date Sort by votes
Use SELECT with LIKE and use underscore to indicate any character.

Andrew
Hampshire, UK
 
Upvote 0 Downvote
Did you look in the manual specifically under String Functions for substring? Since you mentioned it I thought it would be worth your while reading the manual to see what substring does. (Hint: it will do what you are looking to do)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
428
Chris Miller
Chris Miller
waubain
  • Locked
  • Question
Show rows results on same row when Group BY fields 1
Replies
6
Views
370
SkipVought
S
Samus Aran
  • Locked
  • Question
Looking for specific data using SELECT
Replies
0
Views
141
Samus Aran
Samus Aran
trandrus
  • Locked
  • Question
incrementing a column without having to query the db first
Replies
4
Views
176
Chris Miller
Chris Miller
madcelt
  • Locked
  • Question
Select query not showing error but not showing result either
Replies
2
Views
153
madcelt
madcelt

Part and Inventory Search

Sponsor

Back
Top