[Resolved] SQL booboo

[Ice725]

After hours of coding, I realized I got myself into a major bind. I'm writing a function to delete a users from a database.

My problem is, the database has 2 fields, firstname and lastname. My parameter in my function is one string that consist of their full name, not broken down into first and last.

Here's what I'm seeking...

DELETE FROM users WHERE name = 'Joe Dirt'

That would work fine, but my database has name broken into first,last.

I need to do something like this

DELETE FROM users where firstname + ' ' + lastname = 'Joe Dirt'

(firstname nad lastname are columns in my db)
Obvisously that doesn't work, but is there a way you can combine two varchars with a space between them in mysql commandline??

[LordShryku]

Why not [man]explode[/man] the variable on the space? The other option would be to use concat (look that up in the MySQL manual)

[Ice725]

I'll just restructor the DB...
I guess there's no reason to have separate fields in the database

[LordShryku]

While you're restructuring, consider putting a unique primary key per user in there. It's really not safe to delete by a string value. This will make management easier....