I have to develop an application and I have to populate a database with "realistic" data about songs (title, duration), album(title, year, url) and artist(name).
I tried to read the documentation but I can't figure how to generate a "semi-random" choice. What I want is something like:
select * from music.release.search(x,x+100) where keyword like '%'
But a similar query is not accepted by the system because keyword want an "=" and not a "like". I tried also to perform the following query:
http://query.yahooapis.com/v1/public/yql?q=select * from music.release.search(1000,1200) where keyword = '*'
But it returns only 93/94 results and they continuously repeat.
Is there any way to solve this problem.
Any ideas?
Thanks a lot for this possibility.
Alberto