Beginning MySQL Tutorial
One of the fastest SQL (Structured Query Language) database servers currently on the market is the MySQL server, developed by T.c.X. DataKonsultAB. MySQL, available for download at http://www.mysql.com, offers the data base programmer with an array of options and capabilities rarely seen in other database servers. What's more, MySQL is free of charge for those wishing to use it for private and commercial use.
| Name: |
Dan |
| Subject: |
SQL Syntax |
| Date: |
08-05-1999 05:36AM |
Hello. My apologies if this sounds convoluted. Using MySQL, is there a way to query only records containing certain data? I am trying
to get the emails with only the 'net' suffix from the "email" column, but only from records containing certain names in the "firstname" column. I've tried and failed
with the following queries:
<![CDATA[
SELECT *
FROM Members
WHERE Members.firstname="kristy"
OR Members.firstname="jenny"
OR Members.firstname="kimpon"
AND Members.email="*net*" ;
--------------------------------------------
SELECT *
FROM Members
WHERE (Members.firstname="kristy"
AND Members.email="*net*")
OR (Members.firstname="jenny"
AND Members.email="*net*")
OR Members.firstname="kimpon")
AND Members.email="*net*";
]]>
If this cannot be done in one step, could anyone please brief me
on how I can query a query using MySql?
Thanks much,
Dan H.
|
Other posts in this thread:
| Top | | • SQL Syntax | Dan | 08-05-1999 05:36AM |
Reply to this post:
|
 |
Visit the MySQL Forum!
New On DevShed:
Hot Forum Topics:
|
