Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Order by substring?

Status
Not open for further replies.
elck

elck

Programmer
Apr 19, 2004
176
NL
Is this at all possible?
In any way or form?

Code: 
$query="SELECT title,id,date FROM `content` WHERE `user`='$user' ORDER BY SUBSTRING(title,(INSTR(title,';;')+2)) ASC ";
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

rmak78
  • Locked
  • Helpful tip
LIMIT USERS ACCESS PER DAY BY IP
Replies
0
Views
199
rmak78
rmak78
PeDa
  • Locked
  • Question
POST Content-lLength of ... bytes exceeds the limit of 8388608 bytes in Unknown on line 0
Replies
4
Views
467
feherke
feherke
bsanderson
  • Locked
  • Question
How do I add a link to change sort order?
Replies
2
Views
239
bsanderson
bsanderson
PeDa
  • Locked
  • Question
Include URL with parameter in table generated by php
Replies
3
Views
410
PeDa
PeDa
cmayo
  • Locked
  • Question
ZipArchive::close is terribly slow when executed by Apache2
Replies
3
Views
450
cmayo
cmayo

Part and Inventory Search

Sponsor

Back
Top