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

[busboy]

I something like this possible?

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


Thanks!

[r937]

yup, very possible

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

[busboy]

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%';

[r937]

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

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