Home | Community | Message Board


This site includes paid links. Please support our sponsors.


Welcome to the Shroomery Message Board! You are experiencing a small sample of what the site has to offer. Please login or register to post messages and view our exclusive members-only content. You'll gain access to additional forums, file attachments, board customizations, encrypted private messages, and much more!

Kraken Kratom Shop: Red Vein Kratom

Jump to first unread post Pages: 1
Invisibleelbisivni

Registered: 10/01/06
Posts: 2,839
MySQL Q
    #7777840 - 12/19/07 02:15 PM (16 years, 1 month ago)

How can I write a mysql_query to select records beginning with an integer 0-9?

Code:
$recordset=mysql_query("SELECT * FROM records WHERE name=int(1)");


Something like that?


--------------------
From dust you are made and to dust you shall return.


Extras: Filter Print Post Top
Invisibleslackophage
Misanthropist
Male User Gallery


Registered: 11/16/06
Posts: 1,112
Loc: Seattleish
Re: MySQL Q [Re: elbisivni]
    #7777856 - 12/19/07 02:18 PM (16 years, 1 month ago)

Code:

SELECT * FROM records WHERE name REGEXP '^[0-9]'



Extras: Filter Print Post Top
Invisibleelbisivni

Registered: 10/01/06
Posts: 2,839
Re: MySQL Q [Re: slackophage]
    #7778032 - 12/19/07 02:58 PM (16 years, 1 month ago)

Thanks much (:

I tend to rely on the internet for finding answers to all of my questions but I really should find a good MySQL book.


--------------------
From dust you are made and to dust you shall return.


Extras: Filter Print Post Top
InvisibleMontanahunter420
Mushroom Hunter
Male User Gallery


Registered: 05/10/06
Posts: 1,188
Re: MySQL Q [Re: elbisivni]
    #7778470 - 12/19/07 05:09 PM (16 years, 1 month ago)

:smile: Books are a way of the past.


--------------------
All of my posts are purely fictional and for hypothetical purposes.


Extras: Filter Print Post Top
InvisibleSillicybin
Registered: 02/14/05
Posts: 2,134
Loc: Flag
Re: MySQL Q [Re: Montanahunter420]
    #7795407 - 12/24/07 12:05 PM (16 years, 1 month ago)

REGULAR EXPRESSIONS ARE YOUR FRIEND when it comes to SQL queries.

Learn them. Use them. Love them.


Extras: Filter Print Post Top
Jump to top Pages: 1

Kraken Kratom Shop: Red Vein Kratom


Similar ThreadsPosterViewsRepliesLast post
* PHP/MySQL help daytripper05 1,182 7 04/20/08 10:48 PM
by ectolysergic
* mysql help automanM 596 4 11/20/07 05:56 PM
by automan
* PHP/MySQL question daytripper05 983 7 04/28/08 04:43 PM
by daytripper05
* hooking openoffice to mysql automanM 781 2 07/22/05 02:54 PM
by automan
* ATTN: PHP/MySQL Gurus
( 1 2 all )
elbisivni 2,075 20 09/04/07 06:04 PM
by elbisivni
* PHP/MySQL question elbisivni 763 4 05/15/08 01:25 PM
by elbisivni
* Evolution, specializtion, and natural selection SeussA 1,206 7 10/02/05 12:36 PM
by trendal
* PHP, MySQL Programmer (job offer in craigslist chicago!) ZippoZM 578 0 07/11/06 02:20 PM
by ZippoZ

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: trendal, automan, Northerner
527 topic views. 0 members, 2 guests and 1 web crawlers are browsing this forum.
[ Show Images Only | Sort by Score | Print Topic ]
Search this thread:

Copyright 1997-2024 Mind Media. Some rights reserved.

Generated in 0.021 seconds spending 0.007 seconds on 14 queries.