Caveat with new search results Nov07 '05

Feedback

# (1 of 3): Jennifer Grucza » jennifergrucza.com

3 hours, 40 minutes after the fact. (Mon 07 Nov 2005, 11:30 AM CST)

You might want to take a look at the UNION command in SQL. With it, you can select data from multiple tables, so long as the columns you're selecting have the same datatypes in both tables.

# (2 of 3): Matthom

5 hours, 16 minutes after the fact. (Mon 07 Nov 2005, 1:06 PM CST)

Indeed, Jennifer - that would be my answer! Thanks for pointing that out.

Only problem... upon checking just now - my server's current version of MySQL is 4.1.14.

UNION begins support in version 5, right? At least I think that's right...

Previous comment Return to entry

# (3 of 3): Matthom

5 hours, 22 minutes after the fact. (Mon 07 Nov 2005, 1:12 PM CST)

Ooops, no - I'm wrong. UNION is supported in versions 4, and up. So I'm set!

Previous comment Return to entry

RSS feed for comments on this post

Leave feedback

Feedback

Input format: The editor controls below will assist with Markdown syntax.

Status

Sub-status

Your info Name: Email (will not show on page):

Follow new comments via email? (You can turn this off any time)

Do you want your comments emailed to yourself?

Home Page (optional):

Return to entry.

matthom is published and produced by Matt Thommes - an independent publishing enthusiast, mobile blogger, content creator, informative writer, web developer from Chicago. Never one to conform, Matt intends to promote the effect the web has on our lives, in an effort to intensify, instruct, and clarify all that is happening around us.

Contact Matt

I just realized a big hole in my new search capabilities, at this site.

You are at the feedback permalink page for: Caveat with new search results