MySQL Forums
Forum List  »  Newbie

search problems
Posted by: M Rankin
Date: March 16, 2016 10:04AM

hi
i have created a database containing names and genres of bands.
when someone searches the database for a band it is meant to return the genre of that band and all other band of the same genre.

so with a layout of;

deep purple rock
ac/dc rock
adele pop
shania twain pop
shania twain country
black sabbath rock

if i search for 'deep puprple' i want it to return 'rock' but also ac/dc and black sabbath.

i'm having no success with the sql query.
does anyone have a suggestion?
thanks

Options: ReplyQuote


Subject
Written By
Posted
search problems
March 16, 2016 10:04AM
March 16, 2016 11:24AM
March 17, 2016 12:42PM
March 16, 2016 05:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.