Re: query for twin primes

2011-07-14 Thread Simcha Younger
bound? select prime.* from prime join prime as p2 on prime.pv+2=p2.pv where prime.oid 100; -- Simcha Younger sim...@syounger.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: ` vs '

2011-03-30 Thread Simcha Younger
' asc LIMIT 10; When you use quotes you are no longer referring to the column, instead the order orders by the string 'name'. This is a meaningless sort, and your results wil not be ordered at all. Thanks Brent -- Simcha Younger sim...@syounger.com -- MySQL General Mailing List For list

Re: Problem filtering with a like expression

2011-03-21 Thread Simcha Younger
. INCORRECT! Again correct, you tried to match `name` against boolean TRUE (the evaluation of you expression). Best regards, Johan -- Simcha Younger sim...@syounger.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: I can't have group as a column name in a table?

2011-02-24 Thread Simcha Younger
backticks, not quotes. `group`, not 'group'. -- Simcha Younger sim...@syounger.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Unknown column 'users.users_id' in 'where clause'

2011-02-03 Thread Simcha Younger
' for the part of the statement that I've marked as *bold* and how I can over come this problem ? You have to add the users table to the subquery. Your subquery only has the fixtures_results table in the 'from' clause, and the subquery is not aware of the tables you use in the outer query. -- Simcha

Re: Help with query.

2011-02-02 Thread Simcha Younger
Halliday http://www.pintumbler.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=sim...@syounger.com -- Simcha Younger sim...@syounger.com -- MySQL General Mailing List For list archives: http

Re: Sending an output of a query to file in debian lenny

2010-12-02 Thread Simcha Younger
the problem? You probably have apparmor installed, and it prevents mysql from writing to any directory other than the mysql data directories, regardless of which user it is running under. -- Simcha Younger sim...@syounger.com -- MySQL General Mailing List For list archives: http

Re: Missing results.

2010-11-04 Thread Simcha Younger
. -- Simcha Younger sim...@syounger.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: update and times

2010-10-07 Thread Simcha Younger
On Wed, 06 Oct 2010 17:48:55 -0400 kalin m ka...@el.net wrote: Simcha Younger wrote: executing this query didn't update the record. why? The two values you have here are equal: sample data : 12862162510269684 query: where unix_time 12862162510269684

Re: update and times

2010-10-05 Thread Simcha Younger
12862162510269684 and therefore the 'less than' query did not match that row. -- Simcha Younger sim...@syounger.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: [PHP] MySQL select matching

2010-07-21 Thread Simcha Younger
the same. select distinct id from `table` where concat(`b`, `c`, `d`) in (select concat(`b`,`c`,`d` from `table` where id = '0001') AND id != '0001'; (untested) -- Simcha Younger sim...@syounger.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe