busboy — 2012-08-20T17:54:05-04:00 — #1
I something like this possible?
select uID, entryText from communications where uID not in entryText;
r937 — 2012-08-20T19:42:18-04:00 — #2
yup, very possible
WHERE entryText NOT LIKE CONCAT('%',uID,'%')
busboy — 2012-08-20T21:09:55-04:00 — #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%';
r937 — 2012-08-20T21:15:42-04:00 — #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
SET entry = REPLACE(entry,'Guide','Sponsor')
WHERE entry LIKE 'Guide%';
mittineague — 2014-09-18T23:32:20-04:00 — #5
This topic is now archived. It is frozen and cannot be changed in any way.