How to select the field that contains numbers and letters?

Question

My sql script is like this :

SELECT hotel_code, star FROM hotel WHERE star REGEXP '^[A-Za-z0-9]+$'

The result is like this :

I want the result of select the field that contains numbers and letters.

So, the result is like this :

3EST
2EST

Any solution to solve my problem

Thank you

try using `REGEXP '[A-Za-z0-9]+$'` – akhilp2255 Apr 08 '16 at 06:44 — akhilp2255, Apr 08 '16 at 06:44
Try using this REGEXP : `[0-9].[A-Za-z]` – DevLoots Apr 08 '16 at 06:47 — DevLoots, Apr 08 '16 at 06:47

score 2 · Accepted Answer · answered Apr 08 '16 at 07:01

2

I guess you're trying to get Must alphanumeric values. It can be achieved by following.

^([0-9]+[A-Za-z]+[0-9]*)|([A-Za-z]+[0-9]+[A-Za-z]*)$

answered Apr 08 '16 at 07:01

Alok Patel

score 0 · Answer 2 · answered Apr 08 '16 at 06:47

0

The solution seems be like that:

'^[A-Za-z]+[0-9]+[A-Za-z0-9]+$|^[0-9]+[A-Za-z]+[A-Za-z0-9]+$'

You'll find elements beginning with letters and numbers OR numbers and letters and then containing both ones.

answered Apr 08 '16 at 06:47

Andrewus

score 0 · Answer 3 · answered Apr 08 '16 at 07:15

0

you can try with this..

SELECT hotel_code, star FROM hotel WHERE star REGEXP '^(?=.*[a-zA-Z])(?=.*[0-9])'

answered Apr 08 '16 at 07:15

Himanshu Upadhyay

3 Answers3