php - MYSQL 选择逗号后的值

Question

对 mysql 很陌生，我有一个文本列。值有两种可能的输入场景:

TIME
hour, second

或

NAME
second

如何检查该值是否具有第一种格式(小时和秒均以逗号分隔)，如果是，则仅选择“第二”？

Answer 1

//Assume that you have two formats only for your input like :

$input = '6, 30';

//or 

$input = '30';

//Maybe you can try to explode your input into array first with comma :

$input_array = explode(",",$input);

//Then you check whether there is second value in your array or not, if yes then take the second value, else take the first one:

$value = count($input_array) > 1 ? $input_array[1] : $input_array[0];

//Here you will always get the right value :

echo $value;