concat() Help with querry

[thetylercox]

I have the folloowing list

 

 

orderfrom                                          |Name

---------------

ClearVision, Oakley, I-Deal Optics      | ClearVision

ClearVision, Oakley, I-Deal Optics      |I-Deal Optics

ClearVision, Oakley, I-Deal Optics      |Oakley

 

I want a querry that doesnt show these if name is in orderfrom

 

example:

orderfrom                                          |Name

---------------

ClearVision, Oakley, I-Deal Optics      | ClearVision(Would NOT return this record)

ClearVision,                                        |I-Deal Optics(Would return this record)

ClearVision, ,                                      |Oakley(Would return this record)

 

I Tried the following! whats important is the very last part please over luck anything else you see as to its working!

 

SELECT * FROM `dist` JOIN `patientacct` ON `patientacct`.dist LIKE CONCAT('%', `dist`.name ,'%')
inner join `treasure` on `treasure`.`id` = `patientacct`.`id` where (status = 'To Order' and

This part is where I need help!(( `dist`.name not like CONCAT('%',`patientacct`.orderfrom,'%')) ))

order by `name` ASC

 

 

IN need of help thanks to all!

Going to eat will reply when i return if i get a helpful samaritan!

[Barand]

try

 

WHERE NOT INSTR(orderfrom, name)

[thetylercox]

Thanks a million ahhhhhhhhhh thank you!