I have entries in a table as follows.
mysql> select name,sid,showclickable from mybb_smilies;
+--------------------+-----+---------------+
| name | sid | showclickable |
+--------------------+-----+---------------+
| Very Happy | 1 | no |
| Very Happy | 2 | no |
| Very Happy | 3 | no |
| Smile | 4 | no |
| Smile | 5 | no |
| Smile | 6 | no |
| Sad | 7 | no |
| Sad | 8 | no |
| Sad | 9 | no |
| Surprised | 10 | no |
| Surprised | 11 | no |
| Surprised | 12 | no |
| Confused | 13 | no |
| Confused | 14 | no |
| Cool | 15 | no |
| Cool | 16 | no |
| Cool | 17 | no |
| Laughing | 18 | no |
| Mad | 19 | no |
What I need to do is have just one of each 'name' to have 'showclickable' set to 'yes'.
For example
mysql> select name,sid,showclickable from mybb_smilies;
+--------------------+-----+---------------+
| name | sid | showclickable |
+--------------------+-----+---------------+
| Very Happy | 1 | yes |
| Very Happy | 2 | no |
| Very Happy | 3 | no |
| Smile | 4 | yes |
| Smile | 5 | no |
| Smile | 6 | no |
| Cool | 15 | yes |
| Cool | 16 | no |
| Cool | 17 | no |
| Laughing | 18 | yes |
| Mad | 19 | yes |
I'd be very appreciative if someone could give me an SQL query that'd do that.
Thanks