Jim Elliott
Reputation: 37
Create a non-existent field in MySQL view
If possible I want to create a non-existent field in a MySQL view.
Say select * from authors
Then, if there is a field living and it is 1, I want to add a field image and assign it a value of tick.gif. Is this possible?
It is so I can easily use a rather flash grid program!
Upvotes: 0
Views: 103
Answers (1)
tijs
Reputation: 566
you can try
select a.*, if(a.living = 1, "tick.gif", NULL) as image from authors a
Upvotes: 1
Related Questions
- mysql create view only if it doesn't already exist
- create if not exists view?
- Mysql View new field value
- Using a created column in a view
- Create a VIEW with null value in MySQL
- Insert data from mysql view into a table where not exist
- MySQL: create view if it doesn't exist, but don't alter it if it does
- how to add a field if not exists in mysql table
- Adding blank(null) field to mysql table
- How to create an empty VIEW in mySQL