This might be really easy, but I'm just not sure how to write this
query and my searching on google isn't finding me things, probably
because I am searching for the wrong terms.
I have a bunch of records where the "area" column is like:
animal-dog-5
animal-dog-3
animal-cat-1
animal-cat-22
an
Select DISTINCT area from table like '$searchterms%';
In SQL, you can use the 'LIKE' keyword along with the '%' and '_'
wildcards.. '_' is one character, '%' is any number of chars.
-Micah
Kevin Murphy wrote:
This might be really easy, but I'm just not sure how to write this
query and my s
Well, its not really a search that would be way easier. :-) What
I'm looking for is a query that will give me the complete list of
items that are distinct, minus the last number after the last hyphen.
animal-dog
animal-cat
animal-bird
--
Kevin Murphy
Webmaster: Information and Marketing
Oh! I misunderstood..
This is tougher, you're selecting the entire set, so you won't have
anything after 'WHERE', but you're defining how the returned items are
formatted, this goes before table selection:
Select DISTINCT SUBSTRING_INDEX(`area`, '-', 2) from table;
I didn't test this, but i
i'm a bit confused. if i'm getting you right heres my 2 cents:
first you do sql query using DISTINCT
when the result are returned to you, you can then run thru the result array
using preg_replace. heres an example:
$aVar= array(
'animal-dog-5',
'animal-dog-3',
'animal-c
i'm not sure if it is possible to use regular expression in a sql query.
can
anyone comment on this? thanks.
Mysql & Postgres can. I'm sure others can too.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
You can do regular expression matching in MySQL and I think a few other
servers too, but that's not the same as regular expression replacement
like you can do with PHP.. It just returns a boolean true/false
depending on whether or not the match works.
-Micah
J R wrote:
i'm a bit confused.
thanks for the info. didn't know this. :). i'll be googling how this is
done. :D and perhaps post back a solution to your problem kevin, if i find
one :).
On 8/31/06, Micah Stevens <[EMAIL PROTECTED]> wrote:
You can do regular expression matching in MySQL and I think a few other
servers too, b
J R wrote:
thanks for the info. didn't know this. :). i'll be googling how this is
done. :D and perhaps post back a solution to your problem kevin, if i find
one :).
No need to google, go straight to the source:
http://dev.mysql.com
--
Postgresql & php tutorials
http://www.designmagick.com/
