Mysql query with burst

Question

I have a table with this value type 20 | 10 | 5 | 8 | 19 | (with separator)

I need to select rows where the first value (e.g. after explosion) is less than 20.

$arr = explode("|", "goal_times");
$first_goal_time = $arr[0];

But how to do it in Mysql query?

+3

Hayk Makyan Jul 24 At 8:55 am

1 answer

vhu · Answer 1 · 2015-07-24T08:58:18+0000

In general, you shouldn't have multiple delimited values in the same column. In this case, you can get away withSUBSTRING_INDEX()

SELECT * 
 FROM yourtable 
 WHERE 
  SUBSTRING_INDEX(yourcolumn,'|',1) < 20;