| |
| |
| |
|
Comments:
<0> I'm using mysql and have a table full of imdb movie data. I'm looking up movie-named folders in the table, but some of the lookups fail because the real movie names have colons, while I can't put colons in a folder name. Is there some way to filter out the colons from a WHERE comparison on the fly?
<0> I don't want to permanently remove the colons from the movie titles
<1> what the **** is "colons" ?
<2> (Sinorm): SQL should have a replace() function
<2> and colons are :s
<1> are what ?
<1> oh
<1> ":"
<2> heh, yah
<1> weird name
<1> I never thought about it
<1> lo
<1> l
<0> replace function? I'll check it out
<0> thanks
<3> how would i be able to do something similar to:
<3> SELECT id, name, company, email, subscribed FROM subscribers WHERE cid = 1 ORDER BY id DESC INNER JOIN group_permissions ON group_permissions.sid = subscribers.id
<3> of course, that wont work. but i am suggesting an INNER JOIN based on an already queried table. I have googled and read books to no avail :P
<3> obviously i was not looking for the right thing.
<4> well
<4> you could use a subselect, ommiting ORDER BY
<4> also, you can make a view from the first select, then join second one to the view
<5> hi
<4> hi
<5> a greet after 70 mins
<5> hehe
<4> :D
<5> well i wasnt that alive anyway
<5> missing sleep
<4> better later than never, u kno
<5> these morons havent uploaded the party pics yet
<3> hi imap, thanks for your advice. :)
<3> um, lets say i create a view...
<3> if this query were to be executed simultaneously in multiple sessions at once. would there be issues in regards to naming conventions of the name?
<3> or is the view unique to each session?
<6> I'd like to update a field from the results ofa select top
<6> anyone able to help me out with that query?
<6> i figure some knd of subquery but I'm not there yet
Return to
#sql
or
Go to some related
logs:
ops kossa dappa
letter generating sequences in C++
#chat-world
#india
irc.lepaknet.org
inteI v6
#allnitecafe
#allnitecafe
#php
#worldchat
|
|