SQLTeam.com | Weblogs | Forums

All rows Fetched: 0 in 0.003 seconds


#1

Hi,

IF ANYONE CAN POINT OUT THE OBVIOUS TO ME I AM COMPLETE BEGINNER COVERING FOR AN RECENTLY LEFT I.T. EXPERT.

THIS QUERY PRODUCES NO ROWS ALTHOUGH WHEN I SEARCH FOR THE FIRST FEW user_sampleid INDIVIDUALLY THEY ARE ALL GENERATING ROWS.

THERE ARE MANY MORE user_sampleid IN MY FULL QUERY. IS IT THAT ONE IS NOT A VIABLE SEARCH AND THAT RUINS THE REST OF THE QUERY RETURN?

select SAMPLE_ID, USER_SAMPLEID, CONTAINER_NAME, POSITION, SAMPLE_TYPE, VISIT, LOCATION
from IAVI_CONTAINER_SAMPLES where user_sampleid like ('B00202004%PBMC%'',
''B00202022%PBMC%'',
''B00422050%PBMC%');

MANY THANKS


#2

You're probably looking for:

 where user_sampleid like 'B00202004%PBMC%'
    or user_sampleid like 'B00202022%PBMC%'
    or user_sampleid like 'B00422050%PBMC%'

#3

TURN OFF CAPS LOCK... No one likes being yelled at.