what defines a number in php?

[jandrews]

Hi,

 

Its easy enough to display a query with all results beginning with a letter:

$query_artists = sprintf("SELECT playlist_music FROM flamplayer_musics WHERE playlist_music LIKE '%s%%' GROUP BY playlist_music ORDER BY playlist_music ASC", 

 

...but what if some of your database entries begin with a number? how do you ask for all results beginning with a number?

[trq]

Sql queries are sql, not php, moving.

[Yesideez]

You do the same but use a number instead of a letter.

[Maq]

Found this solution on another forum:

 

Select * from table_name where column REGEXP '^[0-9]';