mysql query

[andyd34]

I want to fetch a certain group form a mysql table which are stored in the username field I think it will have to be something like this

 

SELECT username
FROM session_users
WHERE username REGEXP 'Guest_[1-5]'
ORDER BY username  DESC;

 

I am not sure if this is right, i dont think it is but its not too far away, the reason for this is to auto increment the Guest users to give each one a unique id. i.e. Guest_1, Guest_................ , Guest_344 and so on.

 

Dos anyone have any ideas how i may do this

[andyd34]

Well that was easy

 

WHERE username REGEXP 'Guest_'