Jump to content

scampisi

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

scampisi's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Thanks a million. That worked great.
  2. I have a situation where I am needing to sort a list alphabetically by the last name. However, due to BAD planning, all of the names are stored in a single field like this [i]firstname lastname[/i] What is going to be my best way to sort my list? I looked through string manipulation in MYSQL, but I couldn't find a way to doa select statment that would search through my table, and pull all names based on the lastname. SELECT * from catalog ORDER BY . . . and here I want to say ORDER BY "the first character after the first space in " FULLNAME Any ideas?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.