Order by substring? 1

[elck]

Is this at all possible in any way or form?

$query="SELECT title,id,date FROM `content` WHERE `user`='$user' ORDER BY SUBSTRING(title,(INSTR(title,';;')+2)) ASC ";

 

[r937]

yes

r937.com | rudy.ca

 

[elck]

Thanks, it works too.
At first it didn't, hence my question, but the problems were spaces in front of the substring.

Now the code is even worse:

$query="SELECT title,id,date FROM `content` WHERE `user`='$user' ORDER BY TRIM(SUBSTRING(title,(INSTR(title,';;')+2))) ASC ";

Is this an efficient way, or should I grab all matches in a PHP array and perform the substr function there?

 

[r937]

if you perform the substring in php, you will also have to sort the entire result set yourself, right?

let the database do it

r937.com | rudy.ca

 

[elck]

Thanks