[thelist] [mysql] another sql query...

[Joshua Olson]

> -----Original Message-----
> From: kris burford
> Sent: Thursday, March 11, 2004 10:14 AM
> 
> SELECT t1.id, t1.name
> FROM table_one t1, table_two t2
> WHERE t2.text_field not like '%t1.name%'
> ORDER by t1.name";

Kris,

One small change:

SELECT t1.id, t1.name
FROM table_one t1, table_two t2
WHERE t2.text_field not like '%' + t1.name + '%'
ORDER by t1.name;

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com/service_areas/
706.210.0168