Re: query for twin primes

e twin > primes within certain bound? > select prime.* from prime join prime as p2 on prime.pv+2=p2.pv where prime.oid < 100; -- Simcha Younger -- 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 '

ontact`.`name`, ORDER > BY 'name' 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 >

Re: Problem filtering with a "like" expression

ookup where name like ('A' || '%'); > => same as previous and returns nothing. INCORRECT! Again correct, you tried to match `name` against boolean TRUE (the evaluation of you expression). > > Best regards, > > Johan -- Simcha Younger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

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

, not quotes. `group`, not 'group'. -- Simcha Younger -- 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'

#x27; > 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 yo

Re: Help with query.

ight be set, and you need to count each, this will not work. > Thanks! > -- > Paul 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...@syoun

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

3). > What's 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 -- MySQL General Mailing List For list archives: http://lists.m

Re: Missing results.

s were absorbed into your 'group by' clause, since there was an entry, from a later time, which had the same values for all the group by fields. -- Simcha Younger -- 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

On Wed, 06 Oct 2010 17:48:55 -0400 kalin m wrote: > > > Simcha Younger wrote: > >> executing this query didn't update the record. > >> > >> why? > >> > > The two values you have here are equal: > > sample data

Re: update and times

e are equal: sample data : 12862162510269684 query: where unix_time < 12862162510269684 and therefore the 'less than' query did not match that row. -- Simcha Younger -- 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

003 > isn't in the same order as ID 1, but the data is still 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 --