mysql dynamic var

Question

Hello All

A little confused how to create a query and set a dynamic var in the query for output.

Lets say I have a basic table with the following

id | name | type | location

Now I want to do a query and select all data pretty simple stuff

SELECT * FROM TABLE

Which will give me ie.

1 | batman | scifi | row a
2 | matrix | scifi | row b

Bit I want to add a dynamic row to tell me its a video. ie

id| name   | type  | location | category
1 | batman | scifi | row a    | video
2 | matrix | scifi | row b    | video

How can I add this to a query ??

Hope someone can advise!!

Thank you in advance

Answer 1

SELECT *, 'video' category FROM table

That will add a category column that has a value of video for all rows. Is this what you meant?

Answer 2

SELECT  *, 
        'video' AS category
FROM    TABLE