Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: SQL SELECT question.
Started 1 month ago by darkagn
Looks like COUNTRYCODE is a VARCHAR(3) (that is a maximum of 3 character string) so I don't think you can store the Bahamas code in that field. However if you want all country codes that start with a 1, the following may help: Help with Code Tags sql Syntax ( Toggle Plain Text ) SELECT TARIFF FROM RATES WHERE COUNTRYCODE LIKE '1%' SELECT TARIFF ...
Site: www.daniweb.com - IT Tech Talk  www.daniweb.com - IT Tech Talk - site profile
Forum: MySQL  MySQL - forum profile
Total authors: 3 authors
Total thread posts: 4 posts
Thread activity: no new posts during last week
Domain info for: daniweb.com

Other posts in this thread:

joshua__lim replied 1 month ago
• • • • Originally Posted by darkagn Looks like COUNTRYCODE is a VARCHAR(3) (that is a maximum of 3 character string) so I don't think you can store the Bahamas code in that field. However if you want all country codes that start with a 1, the following may help: Help with Code Tags sql Syntax ( Toggle Plain Text ) SELECT ...
Size: 2,577 bytes
Customize:  Customize "<b>Reply 1</b>: SQL SELECT question. :: MySQL :: www.daniweb.com - IT Tech Talk"

saher_omer replied 1 week, 5 days ago
hello all i want to ask if there examples about select statment i have lab exam in sunday
Size: 216 bytes
Customize:  Customize "<b>Reply 2</b>: SQL SELECT question. :: MySQL :: www.daniweb.com - IT Tech Talk"

darkagn replied 1 week, 2 days ago
Hi saher_omer, In future, please start a new thread if your question is not directly related to the original poster's problems. But to answer your question, there are many examples on the net of an SQL select statement. Google will provide millions of them. Here is a good one.
Size: 553 bytes
Customize:  Customize "<b>Reply 3</b>: SQL SELECT question. :: MySQL :: www.daniweb.com - IT Tech Talk"

 

Top contributing authors

Name
Posts
darkagn
2
user's latest post:
SQL SELECT question.
Published (2009-12-06 01:42:05)
Hi saher_omer, In future, please start a new thread if your question is not directly related to the original poster's problems. But to answer your question, there are many examples on the net of an SQL select statement. Google will provide millions of them. Here is a good one.
joshua__lim
1
user's latest post:
SQL SELECT question.
Published (2009-11-14 03:36:01)
&bull; &bull; &bull; &bull; Originally Posted by darkagn Looks like COUNTRYCODE is a VARCHAR(3) (that is a maximum of 3 character string) so I don't think you can store the Bahamas code in that field. However if you want all country codes that start with a 1, the following may help: Help with Code Tags sql Syntax ( Toggle Plain Text ) SELECT TARIFF FROM RATES WHERE COUNTRYCODE LIKE '1%' SELECT TARIFF from RATES...
saher_omer
1
user's latest post:
SQL SELECT question.
Published (2009-12-03 12:45:17)
hello all i want to ask if there examples about select statment i have lab exam in sunday

Related threads on "www.daniweb.com - IT Tech Talk":

Question on SQL Select Statment  www.daniweb.com - IT Tech Talk - site profile MS SQL - forum profile Question on SQL Select Statment
Question on SQL Select Statment
Cfselect issue trying to get results from a sql select...  www.daniweb.com - IT Tech Talk - site profile ColdFusion - forum profile Cfselect issue trying to get results from a sql select statement - ColdFusion
Cfselect issue trying to get results from a sql select statement - ColdFusion
Hi,Need help on sql select statement structure - MS SQL  www.daniweb.com - IT Tech Talk - site profile MS SQL - forum profile Hi,Need help on sql select statement structure - MS SQL
Hi,Need help on sql select statement structure - MS SQL
SQL select statement help - MS Access and FileMaker Pro  www.daniweb.com - IT Tech Talk - site profile MS Access and FileMaker Pro - forum profile SQL select statement help - MS Access and FileMaker Pro
SQL select statement help - MS Access and FileMaker Pro
Insert into sql select statement - Visual Basic 4 / 5 / 6  www.daniweb.com - IT Tech Talk - site profile Visual Basic 4 / 5 / 6 - forum profile Insert into sql select statement - Visual Basic 4 / 5 / 6
Insert into sql select statement - Visual Basic 4 / 5 / 6
How to make this SQL SELECT statement work in ASP.NET  www.daniweb.com - IT Tech Talk - site profile ASP.NET - forum profile How to make this SQL SELECT statement work in ASP.NET
How to make this SQL SELECT statement work in ASP.NET
SQL - Select semi-duplicate rows?  www.daniweb.com - IT Tech Talk - site profile MS SQL - forum profile SQL - Select semi-duplicate rows?
SQL - Select semi-duplicate rows?
Need help with SQL SELECT string  www.daniweb.com - IT Tech Talk - site profile VB.NET - forum profile Need help with SQL SELECT string
Need help with SQL SELECT string
Problems with SQL select statement in VB  www.daniweb.com - IT Tech Talk - site profile Visual Basic 4 / 5 / 6 - forum profile Problems with SQL select statement in VB
Problems with SQL select statement in VB
Reusable SQL Select  www.daniweb.com - IT Tech Talk - site profile Java - forum profile Reusable SQL Select
Reusable SQL Select

Related threads on other sites:

PHP + SQL SELECT question  SitePoint : New Articles, Fresh Thinking for Web Developers and Designers - site profile PHP - forum profile PHP + SQL SELECT question
PHP + SQL SELECT question
C# Embeded sql select question re: command.ExecuteScalar()  Forums - ASP.NET Forums - site profile SQL Server, SQL Server Express, and SqlDataSource Control - forum profile C# Embeded sql select question re: command.ExecuteScalar()
C# Embeded sql select question re: command.ExecuteScalar()
The SQL select i just wrote is ghettoer than the SQL...  Twitter / bobthecow - site profile Justin Hileman - forum profile The SQL select i just wrote is ghettoer than the SQL select you just wrote. Promise. about 12 hours ago from web
The SQL select i just wrote is ghettoer than the SQL select you just wrote. Promise. about 12 hours ago from web
T-SQL: SELECT TOP n. SQL: SELECT ... LIMIT 0,n. Gotta go...  Twitter / jamessocol - site profile James Socol - forum profile T-SQL: SELECT TOP n. SQL: SELECT ... LIMIT 0,n. Gotta go with SQL on this one, Microsoft. 06:53 AM November 10, 2008 from web jamessocol James Socol
T-SQL: SELECT TOP n. SQL: SELECT ... LIMIT 0,n. Gotta go with SQL on this one, Microsoft. 06:53 AM November 10, 2008 from web jamessocol James Socol
SQL select statement question in...  Discussions in microsoft.public.greatplains - site profile microsoft.public.greatplains - forum profile SQL select statement question in microsoft.public.greatplains
SQL select statement question in microsoft.public.greatplains
Thread profile page for "SQL SELECT question." on http://www.daniweb.com. This report page is a snippet summary view from a single thread "SQL SELECT question.", located on the Message Board at http://www.daniweb.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity