Hello,

Here's how my data is stored in the valid_host field:

www.review-script.com,review-script.com

I want to write a query that will select only up to the comma or in other words - www.review-script.com.

Currently I'm selecting the data (select DISTINCT valid_host, created from phpaudit_license) and then using php to get just the first address. I'd like to know how to do it using the select query.

Please advise.

Thanks,

Tim

Ok, again a quetion without specifying which database it is...

Taking a guess for mysql, the manual indicate that you can use an substring_index() function that fit nicely to your requirement:
http://dev.mysql.com/doc/refman/5.0/...ubstring-index

and it really does.
I used this script to test it:

drop table test1;

create table test1(
    valid_host varchar(255), 
    created timestamp
);

insert into test1 values ('www.review-script.com,review-script.com',now());

select substring_index(valid_host,',',1) as valid_host, created from test1;

returns

+-----------------------+---------------------+
| valid_host            | created             |
+-----------------------+---------------------+
| www.review-script.com | 2009-09-30 08:38:56 |
+-----------------------+---------------------+
1 row in set (0.00 sec)

Excellent. Thanks for taking the time!

Tim