#mysql - Tue 13 Mar 2007 between 20:08 and 20:42

NY Lost Funds



XgcAssid: Then it doesn't really match, correct?
Assidselect length(domainto),domainto from smtp where domainto like 'iec-inc.org%' limit 1; results in | 12 | iec-inc.org
archivistkick your trim function
Assidhow the hell is it 12 ???
supposed to be 11
and there isnt any \n select would have displayed it
nihraguki'm trying to craft a SQL query that will delete all rows in a table that do not have a foreign key parent relationship with a row in another table and that have a value in a DateTime column more than 10 minutes older than the present time.
right now i've got this: DELETE FROM wild_coord WHERE DATE_SUB(NOW(), INTERVAL 10 MINUTE) > created AND id != (SELECT wild_coords_id FROM person)
but it doesn't seem to be working as planned
could someone help me out?
alex22hey, is this how i would do the following (select only rows that their dates are > or = to today) SELECT * .... WHERE CURDATE() >= DATE
AssidXgc, Shrews can i pm you?
chadmaynardalex22: dates in the future?
Assidyeah i think its adding a \r or something
alex22chadmaynard, yes
chadmaynardwhat format is the date column in?
alex22date
chadmaynardthen the > should work fine
select * from e1 where date >= curdate();
Assidwill mysql trim() clear \n if its the last character and nothing AFTER that ?
seekwill!man trim
the_wenchsee http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
chadmaynard!man pooh
the_wenchSorry - I have no idea what function you're talking about! but try http://dev.mysql.com/pooh
titoortizi'm trying to pull all records from table a and any matches from table b
shouldn't a left join always pull the record from table a even if there is no match from table b
http://pastebin.ca/393970
even though there is a record in table a it won't show the data if there is no match in table b
gamerIs there a simple way to replace a character string in multiple entries of one table by another with a SQL request ? Like a 'search/replace' or 'sed' command in SQL. Exemple : I want to replace the character string "http://foobar.com" by "http://moohmooh.com" present in some entries of a table named 'text_entries' with a SQL request. Is it possible and if it is, what's the main command ?
titoortizdammit
help me first
update
gamer: update table set url='foo' where url='foo2'
gamerOk, I'll take a look at this command. However, do you think "update table set url='foo' where url='foo2'" will replace 'foo' by 'foo2' in entries like 'blah blah blah foo blah blah' ? Do I need to do update entries using REGEXP ?
titoortizhmm not sure how you would do that
maybe something with substr
or is it substring
gamerOk, I'll take a look at this command too, in the MySQL Reference Documentation
seekwilltitoortiz, In your WHERE, you're requesting b.Year = 2007. In a LEFT JOIN, it will be NULL. Add that critera to your ON condition
ON (a=b AND b=x)

Page: 2 9 16 23 30 37 44 51 58 65 

IrcArchive

NY Lost Funds