Advanced mysql querys - Dev Articles

Dev Articles Community Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

May 18th, 2004, 06:06 PM

Pheifel

Contributing User

Join Date: Mar 2004

Location: Denmark

Posts: 174

Time spent in forums: 43 m 46 sec
Reputation Power: 5

Advanced mysql querys

Hi.

I was wondering: Is there any way to query a db-row where you only query for the first letter in the rowname ? ei.

PHP Code:


		
			
 mysql_query("select * from db where username = '-=the first letter in the username=-'");

- Pheifel

May 19th, 2004, 07:41 AM

dhouston

Contributing User

Dev Articles Beginner (1000 - 1499 posts)

Join Date: May 2003

Location: Tennessee

Posts: 1,355

Time spent in forums: < 1 sec
Reputation Power: 7

PHP Code:


		
			
 mysql_query("select * from db where username LIKE '" . substr($username,0,1) . "%'");

I presume you'd want to select where username is like rather than where username is equal to the first character. The code above will do so.

__________________
Please don't PM me asking for solutions outside the scope of a thread.
Keeping all responses in a thread stands to help others who come along later,
which is after all what this forum's all about.

Viewing: Dev Articles Community Forums > Databases > MySQL Development > Advanced mysql querys

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump