i need to make a select
like
Code: Select all
Select * from categorys where status=1 ORDER BY RAND(), NAME ASC LIMIT 30 so i need to get 30 register random, then the 30 register order by NAME ASC
can anybody help me how i can do this?
also i tried
Code: Select all
select * from categorys where status=1 ORDER BY RAND() AND NAME ASC LIMIT 30