i'm doing a project on SQL Server 2005, i'm stack in searching the data and can't link the data in the data number.. can someone help mi with the programming code? as i can search for the words in the table but i can't link with the data number..
am i doing the correct thing? this command will search for the keyword LIVER. or issit this command? i doing half way through..
SELECT Omim_No
FROM av
WHERE Description LIKE '%LIVER%'
ORDER BY Omim_No ASC
SELECT Omim_No
FROM cs
WHERE CS_Description LIKE '%LIVER%'
OR CS_DATA LIKE '%LIVER%'
ORDER BY Omim_No ASC
SELECT Omim_No
FROM ti
WHERE Omim_Titles LIKE '%LIVER%'
ORDER BY Omim_No ASC
SELECT Omim_No
FROM ti_alt_title
WHERE Omim_Alt_Titles LIKE '%LIVER%'
ORDER BY Omim_No ASC
SELECT Omim_No
FROM tx
WHERE Omim_Text LIKE '%LIVER%'
SELECT subsnp_id,pop_id,allele_id
FROM AlleleFreqBySsPop
WHERE source LIKE '%LIVER%'
SELECT aln_id
FROM b125_Alignments_35_1
WHERE tr_acc LIKE '%LIVER%'
OR ctg_name LIKE '%LIVER%'
OR ctg_acc LIKE '%LIVER%'
OR tr_orient LIKE '%LIVER%'
SELECT ctg_id,exon_number,exon_start,exon_end
FROM b125_ContigExon_1_1
WHERE mrna_acc LIKE '%LIVER%'
SELECT ctg_id,exon_number,exon_start,exon_end,seg_start,seg_end
FROM b125_ContigExon_35_1
WHERE mrna_acc LIKE '%LIVER%'
SELECT b125_ContigInfo_1_1.*
FROM b125_ContigInfo_1_1
WHERE contig_acc LIKE '%LIVER%'
OR contig_name LIKE '%LIVER%'
OR contig_chr LIKE '%LIVER%'
OR group_term LIKE '%LIVER%'
OR group_label LIKE '%LIVER%'
OR contig_label LIKE '%LIVER%'
SELECT b125_ContigInfo_34_3.*
FROM b125_ContigInfo_34_3
WHERE contig_acc LIKE '%LIVER%'
OR contig_name LIKE '%LIVER%'
OR contig_chr LIKE '%LIVER%'
OR group_term LIKE '%LIVER%'
OR group_label LIKE '%LIVER%'
OR contig_label LIKE '%LIVER%'
SELECT b125_ContigInfo_35_1.*
FROM b125_ContigInfo_35_1
WHERE contig_acc LIKE '%LIVER%'
OR contig_name LIKE '%LIVER%'
OR contig_chr LIKE '%LIVER%'
OR group_term LIKE '%LIVER%'
OR group_label LIKE '%LIVER%'
OR contig_label LIKE '%LIVER%'
SELECT b125_CrashedInfo.*
FROM b125_CrashedInfo
WHERE snp_type LIKE '%LIVER%'
SELECT b125_MapLink_35_1.*
FROM b125_MapLink_35_1
WHERE snp_type LIKE '%LIVER%'
OR allele LIKE '%LIVER%'
SELECT b125_MapLinkInfo_35_1.*
FROM b125_MapLinkInfo_35_1
WHERE accession LIKE '%LIVER%'
SELECT b125_ModelInfo_35_1.*
FROM b125_ModelInfo_35_1
WHERE tr_acc LIKE '%LIVER%'
OR donor LIKE '%LIVER%'
OR acceptor LIKE '%LIVER%'
OR alignment LIKE '%LIVER%'
SELECT b125_ProjectedSNP_35_1.*
FROM b125_ProjectedSNP_35_1
WHERE snp_type LIKE '%LIVER%'
SELECT b125_ProteinInfo_34_3.*
FROM b125_ProteinInfo_34_3
WHERE ref_seq_status LIKE '%LIVER%'
OR rna_accs LIKE '%LIVER%'
OR prot_accs LIKE '%LIVER%'
OR nucl_accs LIKE '%LIVER%'
SELECT b125_ProteinInfo_35_1.*
FROM b125_ProteinInfo_35_1
WHERE ref_seq_status LIKE '%LIVER%'
OR rna_accs LIKE '%LIVER%'
OR prot_accs LIKE '%LIVER%'
OR nucl_accs LIKE '%LIVER%'
SELECT b125_SNPContigLoc_34_3.*
FROM b125_SNPContigLoc_34_3
WHERE snp_type LIKE '%LIVER%'
OR phys_pos LIKE '%LIVER%'
OR allele LIKE '%LIVER%'
SELECT b125_SNPContigLoc_34_3_dup.*
FROM b125_SNPContigLoc_34_3_dup
WHERE snp_type LIKE '%LIVER%'
OR phys_pos LIKE '%LIVER%'
OR allele LIKE '%LIVER%'
SELECT b125_SNPContigLoc_34_3_fix.*
FROM b125_SNPContigLoc_34_3_fix
WHERE snp_type LIKE '%LIVER%'
OR phys_pos LIKE '%LIVER%'
OR allele LIKE '%LIVER%'
SELECT b125_SNPContigLoc_35_1.*
FROM b125_SNPContigLoc_35_1
WHERE snp_type LIKE '%LIVER%'
OR phys_pos LIKE '%LIVER%'
OR allele LIKE '%LIVER%'
SELECT b125_SNPContigLoc_35_1_ss.*
FROM b125_SNPContigLoc_35_1_ss
WHERE snp_type LIKE '%LIVER%'
OR phys_pos LIKE '%LIVER%'
OR allele LIKE '%LIVER%'
SELECT b125_SNPContigLoc_35_1_ss_fixed.*
FROM b125_SNPContigLoc_35_1_ss_fixed
WHERE snp_type LIKE '%LIVER%'
OR phys_pos LIKE '%LIVER%'
OR allele LIKE '%LIVER%'
SELECT b125_SNPContigLocusId_1_1_temp.*
FROM b125_SNPContigLocusId_1_1_temp
WHERE contig_acc LIKE '%LIVER%'
OR locus_symbol LIKE '%LIVER%'
OR mrna_acc LIKE '%LIVER%'
OR protein_acc LIKE '%LIVER%'
OR allele LIKE '%LIVER%'
OR residue LIKE '%LIVER%'
OR build_id LIKE '%LIVER%'
SELECT b125_SNPContigLocusId_34_3.*
FROM b125_SNPContigLocusId_34_3
WHERE contig_acc LIKE '%LIVER%'
OR locus_symbol LIKE '%LIVER%'
OR mrna_acc LIKE '%LIVER%'
OR mrna_ver LIKE '%LIVER%'
OR protein_acc LIKE '%LIVER%'
OR allele LIKE '%LIVER%'
OR residue LIKE '%LIVER%'
OR build_id LIKE '%LIVER%'
SELECT b125_SNPContigLocusId_35_1.*
FROM b125_SNPContigLocusId_35_1
WHERE contig_acc LIKE '%LIVER%'
OR locus_symbol LIKE '%LIVER%'
OR mrna_acc LIKE '%LIVER%'
OR mrna_ver LIKE '%LIVER%'
OR protein_acc LIKE '%LIVER%'
OR allele LIKE '%LIVER%'
OR residue LIKE '%LIVER%'
OR build_id LIKE '%LIVER%'
SELECT b125_SNPContigLocusId_35_1_old.*
FROM b125_SNPContigLocusId_35_1_old
WHERE contig_acc LIKE '%LIVER%'
OR locus_symbol LIKE '%LIVER%'
OR mrna_acc LIKE '%LIVER%'
OR mrna_ver LIKE '%LIVER%'
OR protein_acc LIKE '%LIVER%'
OR allele LIKE '%LIVER%'
OR residue LIKE '%LIVER%'
OR build_id LIKE '%LIVER%'
SELECT b125_SNPMapInfo_34_3.*
FROM b125_SNPMapInfo_34_3
WHERE snp_type LIKE '%LIVER%'
OR assembly LIKE '%LIVER%'
SELECT b125_SNPMapInfo_34_3_fix.*
FROM b125_SNPMapInfo_34_3_fix
WHERE snp_type LIKE '%LIVER%'
OR md5 LIKE '%LIVER%'
OR assembly LIKE '%LIVER%'
SELECT b125_SNPMapInfo_35_1.*
FROM b125_SNPMapInfo_35_1
WHERE snp_type LIKE '%LIVER%'
OR md5 LIKE '%LIVER%'
OR assembly LIKE '%LIVER%'
SELECT b125_SNPMapInfo_35_1_ss.*
FROM b125_SNPMapInfo_35_1_ss
WHERE snp_type LIKE '%LIVER%'
OR md5 LIKE '%LIVER%'
OR assembly LIKE '%LIVER%'
SELECT b125_WithdrawCandidates.*
FROM b125_WithdrawCandidates
WHERE subsnp_id LIKE '%LIVER%'
SELECT Batch.*
FROM Batch
WHERE handle LIKE '%LIVER%'
OR loc_batch_id LIKE '%LIVER%'
OR loc_batch_id_upp LIKE '%LIVER%'
OR batch_type LIKE '%LIVER%'
OR moltype LIKE '%LIVER%'
OR synonym_type LIKE '%LIVER%'
OR linkout_url LIKE '%LIVER%'
SELECT BatchCita.*
FROM BatchCita
WHERE citation LIKE '%LIVER%'
SELECT BatchCommLine.*
FROM BatchCommLine
WHERE line LIKE '%LIVER%'
SELECT BatchCultivar.*
FROM BatchCultivar
WHERE line LIKE '%LIVER%'
SELECT BatchMeExLine.*
FROM BatchMeExLine
WHERE line LIKE '%LIVER%'
SELECT BatchPrivLine.*
FROM BatchPrivLine
WHERE line LIKE '%LIVER%'
SELECT BatchStrain.*
FROM BatchStrain
WHERE line LIKE '%LIVER%'
SELECT BatchValCode.*
FROM BatchValCode
WHERE batch_id LIKE '%LIVER%'
SELECT chk_SNPContigLoc_35_1.*
FROM chk_SNPContigLoc_35_1
WHERE snp_type LIKE '%LIVER%'
OR phys_pos LIKE '%LIVER%'
OR allele LIKE '%LIVER%'
SELECT chk_SNPMapInfo_35_1.*
FROM chk_SNPMapInfo_35_1
WHERE snp_type LIKE '%LIVER%'
OR md5 LIKE '%LIVER%'
OR assembly LIKE '%LIVER%'
SELECT Contact.*
FROM Contact
WHERE handle LIKE '%LIVER%'
OR name LIKE '%LIVER%'
|||
Please tell me this is not one command ? It's huge.
At it's core, what you're doing is right, using the LIKE keyword.
|||how to link a result to a number? i mean inside the table..|||
I don't understand. You're selecting from multiple tables. Don't those tables have ID columns ? Can't you use those ?
|||i wan to search for the word and it will display the Omim number and the Omim number will link to another identical number to display the description.. can u do it?|||
Nothing you're saying makes sense to me. You're selecting multiple tables ? why can't you just use the same ID, isn't that what you're saying you want ?
|||because some tables inside contain only numbers so i have to search for the keyword and display the result(omim number) and link this result number to a table contain numbers must be identical numbers. it is so hard that i can't really explain well sorry.. my tasks is hard..|||
I'm sorry, I do not understand the question. What do you want to do ?
|||
first thing is how to search the keywords from the tables
Second thing after u search the result ,how to link the result to a number related to the result?
|||
you use the LIKE keyword to find data inside strings. You return the ID with the string in the query.
|||can u show an example? i wan to search from the whole tables.. will the code be very long?|||
I can't show you an example because I don't know the table schema you're using. You want SQL, right ?
select id, name from tblSomething where name LIKE '%text%'
|||
SELECT av.*,cs.*,ti.*,ti_alt_title.*,tx.*,AlleleFreqBySsPop.*,OmimVarLocusIdSNP.*
FROM av,cs,ti,ti_alt_title,tx,AlleleFreqBySsPop,OmimVarLocusIdSNP
WHERE
av.Omim_No = cs.Omim_No
AND av.Omim_No = ti.Omim_No
AND av.Omim_No = ti_alt_title.Omim_No
AND av.Omim_No = tx.Omim_No
AND av.Omim_No = OmimVarLocusIdSNP.omim_id
AND (
Description LIKE '%LIVER%'
OR CS_Description LIKE '%LIVER%'
OR CS_DATA LIKE '%LIVER%'
OR Omim_Titles LIKE '%LIVER%'
OR Omim_Alt_Titles LIKE '%LIVER%'
OR Omim_Text LIKE '%LIVER%'
)
how?
|||
What's wrong with this ? It will return all the data you could hope for. Do you want to generate new IDs, unique to the query and not in the DB ?
|||I'm glad that I can help