fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
Why bother?
-
Hold on -- by default, all columns are case insensitive....
-
Or you could `diff` the frm files.
-
Returning results before and after the actual result?
fenway replied to Kryptix's topic in MySQL Help
If you ranked them first, then figured out the rank position, then in principle you could do this. -
I also doubt you mean AND.
-
Need help w/ query - indirect match across two tables.
fenway replied to lockon's topic in MySQL Help
I don't understand... give some sample data. -
Then you'll need to join in the table 4 times, and alias columns appropriately.
-
Sounds like you're talking about mod_rewrite... but still, not here.
-
Not that webmin is any better.
-
Turn on php errors.
-
Well, that doesn't make it simple at all -- fields are free. Regardless, show us all of the versions that you'd like to query.
-
Why does the field have arbitrary content? Why no multiple fields?
-
What version?
-
You might have to move that where clause to the join condition.
-
You'll need a php script to do the work.
-
Plesk is evil.
-
Which version?
-
Is there a way to put a subquery into a single, comma seperated field?
fenway replied to tibberous's topic in MySQL Help
select u.id, u.name from users AS u inner join phoneNumbers as p on ( p.owner = u.id ) -
You build your own structure in one pass, then output it in a second pass.
-
What's your definition of a duplicate?
-
Based on what?
-
I have no idea what you're talking about.
-
Don't store totals -- store the raw data.
-
I don't follow.
-
And what does that call to S_I return?