need MySQL command for random value

I need to add a row to my database to return either a number (integer) from 1 to 8, randomly picked OR one of a set of strings: "string1" "string2"..."string8".

They way I will retrieve this value is:

SELECT * from table_name where name="random_number"

The deliverable is to provide me an MYSQL command (ie INSERT INTO ....)

Taidot: PHP

Näytä lisää: Value, strings, php command, Mysql, command, c++ mysql, C# MySQL, c mysql, php insert select, php random name, command command, random name php, need either, quot php mysql, select name, php mysql quot, need name, random integer number, name select, insert mysql, need number, mysql strings, random integer, php value php, select select mysql

Tietoa työnantajasta:
( 15 arvostelua ) westborough, United States

Projektin tunnus: #25926