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;


yup, very possible

     , 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 :wink:

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