Need a better search method

[MrLister]

This is how my tables are set up

ARTISTS:

artistid

artists

SONGS:

songid

artistid

title

I basically need a search method so if somebody searches "usher (artist) burn (song)" it shows a result. some people won't always put it in order some might just do "burn" and some might do "burn by usher"

Full text i can't do because it's in two different tables. Any ideas?

Thanks

[Najjar]

Create a function that returns the artists by the artistid i.e

function convertArtists($id, $return_value) {
Select artists from ARTISTS where artistid = $id
read the artists and return its value
}

Compare the function returned value with the search value i.e

$search_value = convertArtists($id, 'artists');

I use this method all the time it works great.
i hope that helps.