sql regexp syntax

[sp0rk]

I have a small truckload of processor product descriptions in a mysql database, and I'm trying to pick them out by their operationg frequency. Problem is, some are listed in MHz (1000) and other in GHz (1.0), and I can't get the syntax right because (I guess) the period is messing things up.

What I need is regexp ("1000" or "1.0") or something eqivalent...

[sfhc]

This is how I would do that.

This is based on the assumption the the MHz value is always equal to the GHz value. (1000MHz=1.0GHz). As long as that rule holds in the database, then this query will work

Check for 1.0GHz chips:
select * from chipTable where freq like '1.0' OR like '1000'

This query will return matches for both 1.0 and 1000

You would just dynamically change the query depending on what
frequency is being searched for.

[7khat]

In addition you can use % as a wildcard.

select * from chipTable where freq like '%1.0%' OR like '%1000%'

Will match:
1.0
1.0G
1000
1000Mhz, etc...

but this will also match 1.1000 and others .....so....