Help

[popcornplya]

How do I select stuff from database that start with numbers? Thanks.

[Lodius2000]

if you mean database (mysql) column names that start with numbers... you dont, db columns, like php variables cant start with numbers

[popcornplya]

No, If I have movies in my database (mysql) called

007 whatever

123 ways to be cool like popcorn plya

a cool way to be me

 

how can I get the ones that start with numbers only

[Twister1004]

I could be wrong, but to call out stuff in the database you need to use the select statement in php and all that stuff.

 

*~I did not try it!~*

 

<?php

$selectmovie = mysql_query("SELECT * FROM `table here` WHERE `column name here` = 'movie here'");

echo $selectmovie;
?>

[popcornplya]

I could be wrong, but to call out stuff in the database you need to use the select statement in php and all that stuff.

 

*~I did not try it!~*

 

<?php

$selectmovie = mysql_query("SELECT * FROM `table here` WHERE `column name here` = 'movie here'");

echo $selectmovie;
?>

Lol, thanks for the reply but I don't think you understand my question clearly.

[Twister1004]

Well as long as the movie liek 007 is in quotes ('') or ("") then it shouldent effect you.

[popcornplya]

Well as long as the movie liek 007 is in quotes ('') or ("") then it shouldent effect you.

Effect me in what?

[Lodius2000]

my brains not working tonight but heres a couple of ideas

 

-regex in the query identifying the first character as numeric or not (not for sure if mysql supports php regex)

 

- return all the movie titles and shorten them all to 1 character and run is_numeric() on them, but, im really tired and cant remember how to shorten a string, nor can i figure out how to get those results back to the query to get you the right movie titles in their entirety

 

//should get you thinking

 

EDIT: regex is your best bet, query the db for all results, run a preg_match and foreach the results but im terrible at regex so dont ask me

 

//dunno why this got moved

[Lodius2000]

EDIT: regex is your best bet, query the db for all results, run a preg_match and foreach the results but im terrible at regex so dont ask me

 

//dunno why this got moved

[popcornplya]

Anything else?

[fenway]

Anything else?

What was wrong with:

 

WHERE yourColumn REGEXP '[0-9]%'

[mrmitch]

Adding the carat before the group will search at the beginning of the movie name only, so the movie has to start with a number.

 

 

REGEXP '^[0-9]%'

[fenway]

Yeah, that.