selecting rows where a column contents does not exist in another column

I something like this possible?

select uID, entryText from communications where uID not in entryText;


Thanks!

yup, very possible

Code:

---

SELECT uID
    , entryText
  FROM communications
 WHERE entryText NOT LIKE CONCAT('%',uID,'%')

---

Thanks Rudy. And what about something like this to replace one word with another in many rows:

update communications set entry like 'Sponsor%' where entry like 'Guide%';

you need to play around more, try things yourself, look up functions in da manual, et cetera

best way to learn is to do, not to ask ;)

Code:

---

UPDATE communications
  SET entry = REPLACE(entry,'Guide','Sponsor')
 WHERE entry LIKE 'Guide%';

---