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

[kris burford]

hiya

another sql query that i'd like some guidance on if possible.

two tables, i want to select rows from table one which don't contain within 
a text cell in table two details from a field in table one.

so far, i've got:

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

but it either times out on me or returns an empty set (where i *know* i've 
got data that should fit this query).

any suggestions?

kris

(oh, for those *really* interested in yesterday's problem, i decided that 
there was no way i could do a single update request and have decided to 
take down the db, do the multiple update statements, then bounce back up.)


--
kris burford
midtempo ltd
http://www.midtempo.net