art_...@bellsouth.net wrote:
This will not work for my example. I have a select box that was populated
from the db with firstname lastname. The option tag has the value of
firstname+lastname then. Here lies the problem, when I build the query, I
have no way of distinguishing firstname and lastname.
There are two ways to solve this problem. One is to build your select box
differently, so that it passes the data as firstname/lastname or
firstname|lastname or with some other delimiter, then split the data
before entering/examining it.
If you're stuck with the current behavior, though, try:
select [fields] from [table] where concat([firstname],[lastname]) is
[value];
7 messages in com.mysql.lists.mysqlRe: Query help
