Search results for query: *

I have an email field that I would like to count and put the results in a where statement. Longer emails would be suspicious. How do I go about doing that? Thanks! Bill

I have an email variable that I would like to check to see if it contains an uppercase character. In MySQL i was able to use this in my where statement: where ascii(substring(billto_name,2,1)) >= 65 and ascii(substring(billto_name,2,1)) <= 90 How do I use the Case function to check to see if...

Apparently there are no blanks in the numbers since I cut and pasted the IPs and put these IPs into TextEdit. I have used the substring to try remove the extra IP addresses.

I have a huge list of 8500 ip addresses. In some instances, they have port numbers. I have tried importing the list in a temp table and then doing a substring but it still gives me some lines with extra spaces. For example, I did a select substring(ip, 1, 11) from test being the class c...

I got it. I did not realize I could move the local file over. I thought I had to do it on the same sever that the database was on. Thanks for your help. take care Bill

Our Database server has moved off of the local machine and is by itself. When I try to run: load data local infile '/Users/test/Documents/CC.txt' into table bi_kinkead.new_macbook; test.reseller_cc I get an error because the file is not located locally. It is locaed on a server called Pluto...

Ahh.. once I took out the alias it was fine. I was just not thinking. :(

I am trying to update a temp table by querying the values of another table. Here is my SQL: insert into bi_kinkead.vietnam_fraud v select * from bi_warehouse.archive_order_summary a where a.sales_order_num in ("7055089764", "7055106301", "7055218969", "7055220663", "7055233089", "7055283807"...

Thats one way. I wanted to create a chron job and have this script run every week. Is there a different way to do it? Thanks! Bill

I am trying to create a script that will run 2 sql scripts in Korn shell but a little lost. Does anyone have any examples that I can use as a guide? The 2 SQL scripts are called loopers_fiscal.sql and looper_query_v2.sql. Thanks! Bill

I need to create a variable that I can use to calculate the number of weeks in 1 month. Some months will have 5 weeks and some will have 4. Is there an easy formula to do this? thanks! Bill

I have three tables I am trying to do a count on to give me a total amount. The problem is that somes of the sales order numbers are unique to the other tables but I want to count the unique records as well as the records that are not in the other tables. Is there an easy way to do this...

Here is the order_time field: 02:00:59 HH:MM:SS I tried DATE_FORMAT(order_time,CONCAT('%Y-%H','-',(FLOOR(MINUTE(order_time)/15)+1)*15)) as my15min but it does not group it in 15 min increaments. Is there something I am doing wrong? Thanks! Bill

I do not want to limit to just 1 row. If I runt he query as is I get about 13000 records. I then pull a Material Number up and have 7 records when I should just have one. take care Bill

I am trying to build a table that lists products by their material number and their desecription. I am pulling this information from another table. My problem is I am getting mulitple Material Numbers with the same description. Here is my query: create table pricing select distinct...

Is there an Open Source reporting tool for mySQL? I would need it to run on Mac OS X. I have a few I am looking at but they are very hard to configure and use. It would be nice to have something like Business Objects or Crystal Reports. (There is a Business Objects version for the OS X but my...

I have a query where I am doing some counts as data is coming in. There is a order_time field where I am selecting hour(order_time) as hr and then grouping by the data and HR. If I wanted to break the order_time in 15 minute increaments, how would I got about doing that? Thanks! Bill

I have an excel spreadsheet. In my A column, I want to run it to count up if the C column is not null. I have tried the SUMIF but can not seem to get it to work. How can I go about preforming this function? Thanks!

I noticed that mySQL and BO has formed a partnership but have not heard anything with regards to whent his product is coming out. Anyone have any tricks getting mySQL to hook up to BO in the interim? thanks! Bill

I am trying to create a query that will pull back orders where there is more than one item in the list. I have tried to do a count on product_group and then tried doing a count on material_num but it still brings back the unique records. Here is my SQL. Thanks! Bill select order_date...