using join in mysql is not working with where caluse

Question

This is my SQL query:

SELECT Genomics_data_ncbi.Gene_name, Genomics_data_ncbi.Gene_id, 
Drug_targets_new.Genetic_and_biochemical_evidence
FROM Genomics_data_ncbi
JOIN Drug_targets_new ON Drug_targets_new.Gene_name = 
Genomics_data_ncbi.Gene_name WHERE Genomics_data_ncbi.Gene_name LIKE CONCAT ( 
'%', AUO97_RS18755, '%' )
LIMIT 0 , 100

It is showing error - #1054 - Unknown column 'AUO97_RS18755' in 'where clause' — Tina Sharma, Aug 07 '18 at 09:06
Do you mean something like `Genomics_data_ncbi.Gene_name LIKE '%AUO97_RS18755%' ` instead? — user12205, Aug 07 '18 at 09:08

score 0 · Answer 1 · answered Aug 07 '18 at 09:08

0

Probably missing quotes:

LIKE CONCAT ( '%', 'AUO97_RS18755', '%' )

or maybe

LIKE CONCAT ( '%AUO97_RS18755%' )

answered Aug 07 '18 at 09:08

memo

1,868
11
19

Still not working SELECT Genomics_data_ncbi.Gene_name, Genomics_data_ncbi.Gene_id, Drug_targets_new.Genetic_and_biochemical_evidence FROM Genomics_data_ncbi JOIN Drug_targets_new ON Drug_targets_new.Gene_name = Genomics_data_ncbi.Gene_name WHERE WHERE Genomics_data_ncbi.Gene_name LIKE CONCAT ( '%AUO97_RS18755%' ) – Tina Sharma Aug 07 '18 at 09:12
I ma using this command but neither it displays any error nor gives output why? SELECT Genomics_data_ncbi.Gene_name, Genomics_data_ncbi.Gene_id, Drug_targets_new.Genetic_and_biochemical_evidence FROM Genomics_data_ncbi JOIN Drug_targets_new ON Genomics_data_ncbi.Gene_name = Drug_targets_new.Gene_name WHERE Genomics_data_ncbi.Gene_name = 'AUO97_RS18755' – Tina Sharma Aug 07 '18 at 09:27

using join in mysql is not working with where caluse

1 Answers1