Be part of the largest consumer electronics community of the world! Register now and join all the other happy members
| |||||||
| Commercial message | |
| | |
| | | |
|
 |
| | Thread Tools |
18-07-2006
| #1 (permalink) |
| New on Forum Join Date: May 2006
Posts: 15
| Anyone Know SQL? I need to create a search in SQL and the search asks for the latest two of a data set which is stored in date form. If anyone could help I would be very grateful. Also Do you know how to search for a part term within an address i.e. search for just part of an address which is all stored in 1 field. Cheers in advance. |
|  |
|
18-07-2006
| #2 (permalink) |
| Senior Moderator & Reviewer  Join Date: Nov 2005 Location: Keeping my media stash safe.
Posts: 25,369
| Re: Anyone Know SQL? Moved this to the Newbie Forum, as it isn't really a Living Room (off-topic chat) thread... 
__________________ Current drives: Samsung SH-S203N (SB02 patched) + Pioneer DVR-115D (1.06) + Optiarc AD-5170S (1.12) + Litey LH-20A1H (LL0D) + Samsung SH-S182D (SB06 RPC1) x2 + Litey SHM-165P6S (MS0R) + LG E10N (JE07) + BenQ DW1650 (BCDC) x2 + Litey SHW-1635S (YV6P) x2 + BenQ DW1640@164B (BEFB) + LG 4167B (DL13 TDB) + Samsung SH-S162L (TS08) + NEC ND-4551A (1.Z2) + LG GCE-8520B (1.00) + LiteOn SOHR-5239S (2S0B) Retired: LiteOn LDW-851@SOHW-832 + LiteOn SOHW-1693S + LG 4163B My Review PCs How to delete your upper and lower filters : How to check/enable DMA by Womble Click here to join cdfreaks.com and be part of our friendly community!  The CDFreaks Distributed Computing Teams need YOU! Join the Team(s) and help save some lives! Read more here  |
|
| |
|
18-07-2006
| #3 (permalink) |
| CDFreaks Resident  Join Date: Jan 2005 Location: In The Mountains
Posts: 1,649
| Re: Anyone Know SQL? Look here MySQL Reference Manual and see if your question is addressed...
__________________ Main System Intel D865GBF P4 3.2E 4GB DDR400 2x Maxtor 250GB BenQ 1650 BenQ 1620 Matrox P650 InWin Q500/Antec True550 Dual 19"LCD Backup System Intel D865GLC P4 3.0E 4GB DDR400 2x Maxtor 250GB BenQ 1620 BenQ 1650 Matrox P650 InWin Q500/Antec True550 Dual 17"LCD Workhorse System SuperMicro P6DBS P3 850MHz x 2 1GB SDRAM 4x Seagate UW 9.1GB LiteOn 1633S Pioneer A-305S Matrox G450 InWin Q500/PC Power & Cooling 510 ATX Dual 15"LCD Play System AOpen AX4SG P4 2.8E 2GB DDR400 2x Maxtor 160GB BenQ 1620 BenQ 822A Matrox G550 Antec CS600/Antec True550 Dual 17"LCD Server/Firewall Biostar P4TDK P4 2.4GHz 2GB DDR400 2x Seagate 160GB BenQ 1620 LiteOn SOHD 167T Matrox G450 Antec CS600/Antec True550 19" CRT All Computers Use TB SantaCruz Sound Cards & RealMagic Hollywood+ DVD Decoder cards |
|
| |
|
20-07-2006
| #5 (permalink) |
| CD Freaks Junior Member  Join Date: Sep 2004 Location: Ontario, Canada
Posts: 58
| Re: Anyone Know SQL? Its been a long time since I used it but was it something like select col1 from table1 order by date1 descending limit 2; and select col1 from table1 where address like '%something%something%'; and if there is a ' in the search you need to double or quadruple them. I think there is something to wildcard match a single character.
__________________ in and running - benq 1640, benq 162i, LG4082b looking for lodging - LG4520, benq1610 |
|
| |
| |
| |
|
| If you can't find where you are looking for, then become a member and get an answer fast! We have thousands of people online every moment of the day to help you! Click here |
| Bookmarks |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| pl/sql(help me please) | v_piti | General Software | 1 | 15-01-2007 12:57 |
| Possible SQL question..? | v_piti | General Software | 1 | 25-10-2006 10:52 |
| SQL database | siebeduin | Dutch: De Woonkamer | 5 | 18-06-2001 16:00 |
| SQL Server 7 | morgan | Italian: Chat | 2 | 09-03-2001 22:08 |
| Serial for SQL Navigator 3.1? | patuww | CD Freaks Living Room | 0 | 06-06-2000 01:18 |
All times are GMT +2. The time now is 16:58.