SELECT WHERE `foo` LIKE integer%

[maghiel]

I wonder is it possible to do a select statement with a like for any integer value?
don't want to add the numbers manually :p

[maghiel]

damn i hate mondays lol, so ****ing easy :)


SELECT `field` WHERE `field` REGEXP '[0-9]';

[maghiel]

Ok not that easy,

when doeing just the regexp it works,

it doens't work in my (a lot more lines bigger) query.
the query involves some joins, maybe that causez the problem?
would be really nice if someone had an idea :)

[guelphdad]

The blue elephant drank from the daisy while the black dog runs at night!

[guelphdad]

No wait, actually, I have no idea of what could be wrong with your query because you didn't bother to post it.

[Fumigator]

Guelphdad I totally understood your post. :D

[maghiel]

i didn't want to post the whole query because i was to lazy to change all field an table names :p but well, here goes:



SELECT `users`.`id`, `username`, `name`, `labelusername`, `genreid`, `genres`.`title` AS `genre`, `pictures`.`picname`
FROM `users`
INNER JOIN `genres` ON `users`.`genreid` = `genres`.`id`
LEFT JOIN `pictures` ON `users`.`id` = `pictures`.`userid`
WHERE `name` REGEXP '[0-9]'
AND FIND_IN_SET(`users`.`genreid`, \'' . $genreIds . '\')
ORDER BY `name` ASC
LIMIT ' . $pageIndex['offsetMin'] . ', ' . $pageIndex['offsetMax'];

[maghiel]

anyone?

[maghiel]

noone really?

[maghiel]

really noone a thought?