Søgning

Hvordan får man følgende sql til at søge efter flere ord end et?
Fx hvis man i søge feltet skriver anders mekaniker - så finder den alle de poster hvor begge disse ord indgår - også selvom de ikke står lige efter hinanden.

strresult ="select id, billedformat, thumbnail, dias, bestillingsnr, fotograf, beskrivelse, dansk_navn, videnskabeligt_navn, geografisk_lokalitet, land, teknisk_info from diasliste where "
    strresult = strresult&" (( bestillingsnr LIKE '%" & strquery & "%')" 
    strresult = strresult&" or ( fotograf LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( billedformat LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( pictureformat LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( beskrivelse LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( description LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( emneord LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( captions LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( dansk_navn LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( roedliste_status LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( videnskabeligt_navn LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( engelsk_navn LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( familie_latin LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( familie_dansk LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( familie_engelsk LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( orden_latin LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( orden_dansk LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( orden_engelsk LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( geografisk_lokalitet LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( naturtype LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( naturetype LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( amt LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( land LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( country LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( aarstid LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( season LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( kategori_dansk LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( kategori_engelsk LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( underkat_dansk LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( underkat_engelsk LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( kommentar_dansk LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( kommentar_engelsk LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( teknisk_info LIKE '%" & strquery & "%')"
    strresult = strresult&" or ( teknisk_info_eng LIKE '%" & strquery & "%'))"
    if strkat <> "alle" then
        strresult = strresult&" and ((kategori_dansk = '" & strkat & "')or (underkat_dansk = '"& strkat & "'))"
    end if
    strresult = strresult&" order by beskrivelse"
    strresult = strresult& " LIMIT " & start & ", 21"
    set objReS = objconn.execute(strresult)

    If Not objReS.EOF Then
    number = 0
    tdcount = 0