fenway

Just use a table alias and the ambiguity will disappear.

By all means, no one is forcing you to be an active member. But your posts aren't "yours".

So what you need to issue is this: SELECT id, CONCAT(first_name,' ',last_name) AS name FROM free_listings_dealers WHERE id='33' ORDER BY name

Inded... just SELECT incid ... FROM table1 WHERE ... UNION DISTINC SELECT incid ... FROM table2 WHERE ...

You've been a member of these forums for less than 72 hours and you've already decided that I'm humiliating you by asking a simple question so that I can tailor my response. Ask around... see what the general consensus is before jumping to conclusions. That being said, there's a "precision" variable that you can set in php.ini... and since I assume phpmyadmin uses php, that may be helpful.

You may want to look at mysqludf.org... the preg library has perl-like functionality... may be very easy to extract what you need.

There actually is a maximum... but don't worry about it.

If you're referring to me, then I will stop "helping" you forever. Good luck (and learn how to fish).

That doesn' tlook like a php function at all. And it doesn't "work" because now you've changed the name of the field.

I have no idea what wordpress does with this table.

Let me mull over the easiest way to do this... do you have access to the server directly (root access)? There are some UDFs that would be helpful. Click here to donate.

Your original post didn't join any tables... so it shouldn't miss any counts. With joins, you'll need LEFT JOIN.

Actually, I see no MySQL code at all...

That was the command.

You can easily embed fonts in IE... but Mozilla decided this was a "security risk".

ORA? As in Oracle?

Sounds like an DB upgrade to 5.0... shouldn't have happened without your knowledge.

Sorry... CREATE TABLE LIKE 'theothertable'.

Just copy over the structure of that table....

You didn't mention at any point that you needed to extract multiple strings... mysql does not natively support this type of functionality... a while( yourstring =~ s/<match>/g ) makes this trivial. Otherwise, you'll have to do this multi-pass... it would be quite ugly.

2.9? Try again.... anything older than 3.23 is ancient... plus, 2.9 wasn't a release, AFAIK... maybe you're confusing it with phpmyadmin version?

This would be much easier to do with a language that supports regular expressions... I suggest you do this in php.

And what does it produce now?

You don't have to select all the columns...

Please re-phrase your question.