Wednesday, 15 May 2013

mysql - how to get Multiple tuples from where Clause in sqlite database -



mysql - how to get Multiple tuples from where Clause in sqlite database -

if have table

song_name| song_url | artist | year

and have array of string contains name of songs , through name of songs want song_url, artist , year in 1 query

like select song_url,artist,year tbl_music song_name="aaa","bbb"

my problem want columns song_url, artist , year based on names of songs in 1 query

try this

select song_url, artist, year tablename song_name in ("aaa", "bbb");

or:

select song_url, artist, year tablename song_name = "aaa" or song_name = "bbb";

mysql sql android-sqlite android-contentprovider android-cursorloader

No comments:

Post a Comment