[Resolved] wildcard number search

MatrixGL

I am trying to pull out records from a table in a way so that it'd pull out a record only when the field "title" starts with a specific letter or any number in general.

`title` LIKE 'a%' OR `title` LIKE 'A%'

it works, however, if I want to pull out all the records where the title starts with a number, I am having to do this:

`title` LIKE '0%' OR `title` LIKE '1%' OR `title` LIKE '2%' OR `title` LIKE '3%' OR `title` LIKE '4%' OR `title` LIKE '5%' OR `title` LIKE '6%' OR `title` LIKE '7%' OR `title` LIKE '8%' OR `title` LIKE '9%'

Is there any shorter way of doing this?

Thanks in advance 🙂

mtmosier

Not sure about other databases, but if you're using mysql you can use regular expressions.

WHERE `title` REGEXP '^[0-9]'

As another option, you could use substring and "IN".

WHERE SUBSTRING(`title`, 1, 1) IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')

MatrixGL

not working 🙁...using mysql and used REGEXP

SELECT * FROM onedb WHERE `type`='2' AND `title` REGEXP '^[0-9]' ORDER BY 'date' DESC

drew010

it will need to be more like

SELECT * FROM onedb WHERE `type`='2' AND `title` REGEXP '^[0-9].*$' ORDER BY 'date' DESC

to grab something starting with a number followed by more characters.

MatrixGL

Worked! Thank you very much 🙂