Query Query

Anon

Is there any way to do something along the lines of:

SELECT * AS data FROM table

in MySQL?

Anon

yes,
select fieldname as other_name

Anon

Oh, just forgot one thing...

Manuals are your friends, read them.

Anon

Yes Vincent I know you can rename individual fields like that, but that wasn't the question. Can you create an alias to ALL the fields at once. So as I say:

SELECT * AS data FROM table

I've spent many hours reading the MySQL manual and was just wondering if it was an undocumented feature as I can't find it.

/Mike

Anon

For some, manuals make little sense.

Learning through examples is key for many and after this the manual starts to make more and more sense. This is for me too, I'm starting to LOVE the PHP Manual but it's been a long frustrating journey, and continues. I'll be attending a few CIS classes soon though, thankfully.

Still, manuals often times contain words that are difficult to grasp. For me (and others) the examples are of more use. Learning the Lingo is good and requires extra study and effort, effort that all should take but many can't afford. It's all about what you choose. Choices and Time. Now, with that said :

" Three cheers for Examples! "

Examples! Hurraaaaaaay!
Examples! Ahhh Yeaaaahhh!
EXAMPLES! WooHooooOOO!

Oh dear, need sleep and water I think. Oh yeah, Manuals don't always provide fun useful hacks. BUT, Manuals contain information that a surprisingly large amount of people do not possess, so it is to ones advantage to read/reread/rereread the manual. 10x.

Philip

Anon

No.

Anon

Curses..

What about:

SELECT (field1,field2,field3) AS data FROM table

/Mike

Anon

No, but if all you want is a concantenated list try:

select concat(field1,field2,field3) as data from table

Anon

No, but perhaps if you explained why you wanted this and what you were hoping to do, someone might be able to offer a little more informative advice.

Anon

It's just a simple search engine script.

SELECT * AS data FROM table WHERE data LIKE '%keyword%'

was the kind of thing I'm looking to do. It's so much neater than

SELECT * FROM table WHERE field1 LIKE '%keyword%' OR field2 LIKE '%keyword%' OR field3 LIKE '%keyword'...

Yeah?

/Mike

Anon

Sorry, in that case spelling it out is the best you can do.