Explode it inside a query?

[Monkuar]

Here is my query

SELECT id,username,star,color,actions from users WHERE actions >= 1 ORDER BY actions DESC

 

actions field value is "213|1336456267"

 

how can I use mysql to explode so it only reads the first literation of the exploded values, like 213?

 

Is this why people always say you shouldn't store exploded variables?

 

Theres gotta be a way tho right?

 

in other words; is there a mysql function that exploded that actions variable in the query with a | to read only the "213" ?

 

 

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_substring-index

[Monkuar]

http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_substring-index

 

I dont understand the syntax

mysql> SELECT SUBSTRING_INDEX('www.mysql.com', '.', 2);
        -> 'www.mysql'

 

is www.mysql.com supposed to represent the field name or?

 

 

so something like this:

 

SELECT SUBSTRING_INDEX('actions', '|', 2);

 

?

[Monkuar]

$db->query('SELECT id,username,star,color,actions from users WHERE actions >= 1 ORDER BY SUBSTRING_INDEX(\'actions\', \'|\', 2) DESC')

 

WOW

 

TOPIC SOLVED!!!

 

Didn't know you could do this, wow I can store alot of information in explodes now and call them.

 

AwesomE!

[xyph]

You should only store information in explodes (delimited information) when you don't want to query specific values in that data. You're greatly slowing down your query by using SUBSTRING_INDEX