I something like this possible?
select uID, entryText from communications where uID not in entryText;
yup, very possible
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
SET entry = REPLACE(entry,'Guide','Sponsor')
WHERE entry LIKE 'Guide%';
This topic is now archived. It is frozen and cannot be changed in any way.