Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: MySQL Aphlabetical order with DBI

by Asim (Hermit)
on Nov 15, 2002 at 13:47 UTC ( [id://213149]=note: print w/replies, xml ) Need Help??


in reply to MySQL Alphabetical order with DBI

Rather than muck with splitting the name, I suggest you split the data in the database into First and Last Name columns, and use ORDER BY to retrieve results as you need them. This sort of sorting is why you use a database to begin with, as it is more efficent than a program of any sort.

If you really need to do a split, the Lingua::EN::NameParse module is one of a number designed to do the hard work of parsing people's names correctly.

----Asim, known to some as Woodrow.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://213149]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (3)
As of 2024-03-28 17:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found