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

Databases
1

I something like this possible?

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

Thanks!

2

yup, very possible

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

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

4

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