sql where the numbers in the string equals to keyword

Question

I want to search question no. which can be 1, 1a, 1b, 2, 2c, 11. How can I to search 1 getting 1, 1a, 1b but not 11. And if I search 1b, only 1b comes out. Is there any function helps?

using mysql

DATA:
id    |question   |q_no.
1     |XX         |1
2     |ABC        |1a
3     |ED         |1c
1     |CD         |11

Desired sets:
when searching "1":
1     |XX         |1
2     |ABC        |1a
3     |ED         |1c

when searching "1a":
2     |ABC        |1a

sorry for being late

Your question is too vague to be answered. Try: (1) including sample data; (2) desired results; (3) code that you have written; (4) tag the question with the database you are using. Also, a SQL Fiddle can help. — Gordon Linoff
– Gordon Linoff, Commented Aug 29, 2015 at 14:56
Make a function do_sql which takes the first argument for a LIKE where clause in the sql command the function will create. Than call the function with the desired parameters: `do_sql "1b"``. Or explain what you really want and what you have tried. — Walter A
– Walter A, Commented Aug 29, 2015 at 14:58

Fake Face · Accepted Answer · 2015-08-29 15:04:03Z

1

May be this can help. It run in mysql.

SELECT---
FROM---
WHERE question_no REGEXP '1[^1]'

It will show question_no start with character '1' and followed by except character '1'

answered Aug 29, 2015 at 15:04

Fake Face

1164 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gordon Linoff · Accepted Answer · 2015-08-29 15:29:29Z

1

I think regexp is your best approach:

where question_no regexp concat('^', $SearchQ, '[^0-9]')

answered Aug 29, 2015 at 15:29

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Collectives™ on Stack Overflow

sql where the numbers in the string equals to keyword

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related